Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learnerplates
Starting Member
8 Posts |
 Posted - 2007-11-12 : 11:43:27
|
| What is the iso sql query to get the relationships between all tables in a db? |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-12 : 11:49:32
|
| please better describe what information you need, the environment, and what you're trying to accomplish.in sql server the INFORMATION_SCHEMA views contain metadata about the database, but that is the only starting point to guess for you without more information |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
arorarahul.0688
Posting Yak Master
125 Posts |
Posted - 2007-11-13 : 07:19:11
|
quote:
Originally posted by anonymous1
please better describe what information you need, the environment, and what you're trying to accomplish.in sql server the INFORMATION_SCHEMA views contain metadata about the database, but that is the only starting point to guess for you without more information
you can drill by usingInformation_schema.tables or .columns it will more information regarding tables and datatypes of columnsRahul Arora MCA 07 BatchNCCE Israna, PanipatHRY, INDIA######################IMPOSSIBLE = I+M+POSSIBLE |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-13 : 07:23:28
|
Yes, we know. Someone wrote that yesterday.Are you so eager to get the software bundle?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Sql query to get table relationships