O script apenas gera o relacionamento entre as tabelas para uma facil vizualização e documentação.
This script just show the relationship between tables, foreign keys, to easy view and documentation.
Para mais... http://leka.com.br
Ricardo-Leka,
2011-05-23
O script apenas gera o relacionamento entre as tabelas para uma facil vizualização e documentação.
This script just show the relationship between tables, foreign keys, to easy view and documentation.
Para mais... http://leka.com.br
SELECT b.name AS 'Tabela' , a.name AS 'Chave Extrangeira' , c.name AS 'Tabela Pai' FROM sys.foreign_keys A INNER JOIN sys.objects B ON a.parent_object_id = b.object_id JOIN sys.objects C ON c.object_id = a.referenced_object_id ORDER BY b.name ASC
You rated this post out of 5. Change rating
Please join Jim Gray, Distinguished Engineer at Microsoft Research, for this Q&A Session. Jim, the father of Structured Query Language, has been looking at LARGE databases like Google, Hotmail, BarBar, CERN, EOS/DIS, Internet Archive, and others that are either at a Petabyte or will grow to a petabyte scale in the next year or so.
Currently, Microsoft is accepting nominations for the 64-bit version of the SQL Server beta program, code named "Liberty." The Liberty beta program is slated to start in February 2002. Important: You must have access to 64-bit hardware running Windows LE to participate in the Liberty beta program. This beta does not install on 32-bit hardware. Before signing up for the beta, verify that you have access to the appropriate hardware.
With Data Analyzer—the brand-new Office data analysis solution—you can quickly and easily view, analyze, and share business data, giving you the power to make better business decisions.
Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.