command for getting all contraints on table

[sultan]

Hello mates
help NOOBEE here
I want to know is there any command through which we can get all the consraints on a table or in a databases. In the same way how to get the all table names in a database from the command prompt or thorugh query analyzer.

Thanks in advance
bye all -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[ruskin]

Its simple

INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE and INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE

look these up in BOL (Books OnLine)

Hope it helps -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domdom]

you could also use:



Original - sql Code
EXEC sp_helpindex 'TABLE_NAME'

EXEC sp_helpindex 'TABLE_NAME' -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --