list constraints

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

hi

for this u can use sp_help <tablename>

http://msdn.microsoft.com/library/d... />
p_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?
>
>
>

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?
>