System tables


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: System tables

  1. #1
    rkbnair Guest

    System tables



    SELECT table_name,column_name FROM INFORMATION_SCHEMA.COLUMNS

    the above line will result the table details of curretn db.

    In fact where is this (INFORMATION_SCHEMA.COLUMNS) table situated? Can we
    see this table in the tables list?


  2. #2
    JasonL Guest

    Re: System tables


    rkbnair <rkannale@solus1.oceaneering.com> wrote in message
    news:3946350d$1@news.devx.com...
    >
    >
    > SELECT table_name,column_name FROM INFORMATION_SCHEMA.COLUMNS
    >
    > the above line will result the table details of curretn db.
    >
    > In fact where is this (INFORMATION_SCHEMA.COLUMNS) table situated? Can we
    > see this table in the tables list?
    >

    It is a View, and in Enterprise Manager you can see it in the views list.

    -Jason



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center