Re: How to find constraints of a table using SQL

select * from user_constraints where table_name=<table_name>

Pinto

Zhou, Xiaodong wrote in message <977gjd$8a0$1_at_nntp.itservices.ubc.ca>...
>Hi, there:
>
>I want to see the constraints(foreign key, primary key, etc.) of a table.
 I
>don't know how to do it in SQL. Will you please give me some advice?
>Thanks in advance!
>
>Yours xdzhou
>
>
Received on Sat Feb 24 2001 - 00:03:31 CST