OraFAQ Forum: SQL & PL/SQL » How to check table properties? (desc only shows if it is null)

Home » SQL & PL/SQL » SQL & PL/SQL » How to check table properties? (desc only shows if it is null) (11g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How to check table properties? (desc only shows if it is null) [message #578089]

Sun, 24 February 2013 07:33

ashishpatel1992
Messages: 38
Registered: February 2013
Location: India

Member

How to check table properties? (desc only shows if it is null)
If I do desc emp, it only shows the Employee description. But Doesnt tell if table is having primary key or not?
If anyone knows please let me know.
Regards,
Ashish

Report message to a moderator

Re: How to check table properties? (desc only shows if it is null) [message #578098 is a reply to message #578089]

Sun, 24 February 2013 08:06

Michel Cadot
Messages: 54192
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Read ALL USER_% views in Database Reference, we will not do it for you.

You can also query DICTIONARY view:

select * from dictionary 
where lower(comments) like '%constraint%' and table_name like 'USER%'
/

Regards
Michel

[Updated on: Sun, 24 February 2013 08:15]

Report message to a moderator

Re: How to check table properties? (desc only shows if it is null) [message #578106 is a reply to message #578098]

Sun, 24 February 2013 08:12

ashishpatel1992
Messages: 38
Registered: February 2013
Location: India

Member

Wow I didnt knew about it.
Thank You so Much!

Report message to a moderator

Previous Topic:	Need Sql Query
Next Topic:	How to Undo a drop table operation?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 09:33:06 CDT 2013

Total time taken to generate the page: 0.14248 seconds