SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2009
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Need column names in table using query

    hi,

    even though this thread may be silly question for some guys, iam posting.
    pls dont miss understand me.
    i need column names in table using query.

    kindly reply.


    Regards,
    Sunil.

  2. #2
    SitePoint Guru
    Join Date
    Jan 2004
    Location
    Uppsala, sverige
    Posts
    697
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)
    That depends on which DBMS you are using. This is the according to the SQL standard

    Code:
    select column_name from information_schema.columns where table_name = 't'


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •