How to see the existing constraints in a table?

Questions by replyme

Showing Answers 1 - 18 of 18 Answers

subbarao

  • Mar 23rd, 2007
 

by using the command
                               user_constraints

  Was this answer useful?  Yes

selva

  • May 12th, 2007
 

Select constraint_name from user_constraints where table_name=;

Note:
the table name must be capital letter.

  Was this answer useful?  Yes

g_sidhu

  • Feb 12th, 2008
 

SELECT constraint_name, constraint_type

FROM user_constraints

WHERE table_name = 'EMPLOYEES';

safdar

  • Feb 14th, 2008
 

HI I AM SAFDAR DOGAR 
create table dept1(
 deptno number(10) constraints pk_deptno primary key,
 dname varchar2(20),
 loc varchar2(20 )
);
desc user_constraints;

select constraint_name,constraint_type from user_constraints where table_name='DEPT1';
AM I RIGHT

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions