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_USAGE
where table_name='tablename'
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?
>