SQL - How to see the existing constraints in a table?

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 126 of 171

Print

How to see the existing constraints in a table?

Total Answers and Comments: 6

Last Update: February 26, 2008 Asked by: replyme

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 23, 2007 09:33:00

#1

subbarao

RE: How to see the existing constraints in a table?

by using the command
user_constraints

Is this answer useful? Yes | No

May 12, 2007 07:02:29

#2

selva

RE: How to see the existing constraints in a table?

Select constraint_name from user_constraints where table_name ;

Note:
the table name must be capital letter.

Is this answer useful? Yes | No

September 25, 2007 11:53:22

#3

Member Since: September 2007 Contribution: 21

RE: How to see the existing constraints in a table?

Desc user_constrains;

Is this answer useful? Yes | No

February 12, 2008 21:30:21

#4

Member Since: August 2007 Contribution: 122

RE: How to see the existing constraints in a table?

SELECT constraint_name constraint_type
FROM user_constraints
WHERE table_name 'EMPLOYEES';

Is this answer useful? Yes | No

February 14, 2008 05:16:19

#5

Member Since: September 2007 Contribution: 5

RE: How to see the existing constraints in a table?

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

Is this answer useful? Yes | No

February 26, 2008 05:28:43

#6

Member Since: February 2008 Contribution: 278

RE: How to see the existing constraints in a table?

desc table_name

Is this answer useful? Yes | No

Sponsored Links

Sponsored Links

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved