Friday, 23 March 2007

List Tables & Columns

The following SQL can be used to list tables and column names

SQL server

select TABLE_CATALOG,
TABLE_SCHEMA,
TABLE_NAME,
COLUMN_NAME,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH
from .information_schema.columns


Oracle

select OWNER,
TABLE_NAME,
COLUMN_NAME,
DATA_TYPE,
DATA_LENGTH
DATA_PRECISION
from ALL_tab_cols;

2 Comments:

At 15 January 2013 at 07:00 , Blogger dissertationconsultant said...

Superb, brilliant weblog structure! I like your blog post List Tables & Columns and method of writing,

undergraduate dissertations

 
At 22 February 2017 at 10:23 , Blogger James Lackey said...

I am thankful to stumble on this blog post extremely ready to lend a hand for me, as it contains lot of facts. I always choose to read the quality blog content and this thing I found in you blog post. Gratitude for sharing.
custom essay writing service

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home