Home » SQL & PL/SQL » SQL & PL/SQL » How to check table properties? (desc only shows if it is null) (11g)
How to check table properties? (desc only shows if it is null) [message #578089] Sun, 24 February 2013 07:33 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59968
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 Go to previous message
ashishpatel1992
Messages: 38
Registered: February 2013
Location: India
Member
Wow I didnt knew about it.
Thank You so Much!
Previous Topic: Need Sql Query
Next Topic: How to Undo a drop table operation?
Goto Forum:
  


Current Time: Wed Dec 17 20:52:35 CST 2014

Total time taken to generate the page: 0.08231 seconds