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;
at

7 comments:

  1. Anonymous15 January 2013 at 07:00

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

    undergraduate dissertations

    ReplyDelete
  2. Unknown22 February 2017 at 10:23

    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

    ReplyDelete
  3. Lily James8 July 2020 at 11:51

    A large number of students have part-time jobs what makes it quite hard to handle a dissertation properly. When working on dissertation chapters, a hypothesis namely, you will need to put entertainment away and spend all your time undertaking research, planning to buy a dissertation hypothesis.

    ReplyDelete
  4. Anonymous7 August 2020 at 12:59

    Don't struggle with writing a dissertation hypothesis, just make a call or write to us!

    ReplyDelete
  5. Carol Hansen10 August 2020 at 08:56

    Thank you, it helps with no struggling with naming the columns. By the way, you can get guidelines for literature review from experts

    ReplyDelete
  6. Anonymous8 September 2020 at 07:54

    If you need to buy dissertation results from a reliable company, feel free to consult our experts and see what they can offer you.

    ReplyDelete
  7. Ben Aaron23 November 2020 at 13:54

    Get help from dissertation results writing service and improve your grades

    ReplyDelete