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 |
|
Brent555
Starting Member
10 Posts |
 Posted - 2006-05-12 : 01:31:30
|
| i was trying to display constraints but i cant display the type, i dont know wat the type is called to display it |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-12 : 04:23:37
|
| Have a look atINFORMATION_SCHEMA.TABLE_CONSTRAINTS ==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Brent555
Starting Member
10 Posts |
Posted - 2006-05-12 : 04:34:04
|
| yeah i know i cant find nething in there to display the constraint type tho, i wanna be able to display it as a column on its own like in the sp_helpconstraint function but without the other columns in the query |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-12 : 04:59:00
|
| How about INFORMATION_SCHEMA.TABLE_CONSTRAINTS.CONSTRAINT_TYPE==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Brent555
Starting Member
10 Posts |
Posted - 2006-05-14 : 17:23:50
|
| oh ok i see, but i still am unsure how to use it, it just keeps on displaying U for user table when i run it and not the type of constraint from my table |
|
|
|
Brent555
Starting Member
10 Posts |
Posted - 2006-05-14 : 17:29:17
|
| nevermind i got it finally yay, thnx for ur help |
|
|
|
|
|
|
How to display constraint type