MS SQL Server - list constraints

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

list constraints

mcnewsxp

2005-07-29, 9:23 am

how can i use query analyzer to list the constraints for a given table?

Chandra

2005-07-29, 9:23 am

hi

for this u can use sp_help <tablename>

http://msdn.microsoft.com/library/d...p_help_304w.asp

--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---------------------------------------

"mcnewsxp" wrote:

> how can i use query analyzer to list the constraints for a given table?
>
>
>

Hari Prasad

2005-07-29, 9:23 am

Hi,

You could also query the information schema system view.

Select * from INFORMATION_SCHEMA. CONSTRAINT_COLUMN_US
AGE
where table_name='tablenam
e'

Thanks
Hari
SQL Server MVP

"mcnewsxp" <mcourter@mindspring.com> wrote in message
news:utbw6EElFHA.2920@TK2MSFTNGP14.phx.gbl...
> how can i use query analyzer to list the constraints for a given table?
>

Sponsored Links