-
Junior Member
Re: Query to find structure of a table
DESC BOOk_NAME;
eg:
DESC BOOK;
BOOK is name of table.
-
Junior Member
Re: Query to find structure of a table
Sp_help is for SQL server
DESC is for ORACLE DB
Last edited by admin; 11-05-2012 at 12:27 AM.
-
Junior Member
Re: Query to find structure of a table
you can try it by Double click on the data element(data type) of this field and click where
used list icon on the toolbar to find the table which used this data
element.
I hope it will help you
-
Junior Member
Re: Query to find structure of a table
Select column_name, data_type, data_length, data_precision, data_scale from ALL_TAB_COLUMNS
where table_name = 'EMP';
or
desc emp;
Last edited by admin; 01-22-2013 at 07:07 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote