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 |
|
JamesT
Yak Posting Veteran
97 Posts |
 Posted - 2002-04-30 : 16:59:20
|
| Is it possible to extract the DDL for an object (such as a constraint) using T-SQL? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-30 : 18:01:42
|
| Sure is. Have a look at the INFORMATION_SCHEMA views and the system tables. The ones in particular are sysforeignkeys and sysconstraints. |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-30 : 21:55:23
|
| Well that wouldn't exactly give you the DDL.You could call SQL-DMO using sp_OACreate if you were really game. What are you trying to achieve ?Damian |
|
|
|
|
|
|
DDL Extract