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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2005-08-01 : 14:45:01
|
| Hi allCan you please give me the command to find out foreign keys and primary keys in my DB.RegardsNitin Gupta |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-01 : 15:26:15
|
| Check out the INFORMATION_SCHEMA views. Check Books Online for information on them.Tara |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2005-08-01 : 15:57:39
|
| Thanks tara.Got it.It is information_schema.constraint_column_usageRegardsnitin |
|
|
|
|
|
|
Foreign keys