Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2012
    Posts
    6

    Unanswered: how to get column names from view?

    hi all,

    i am trying to get column name from view and print it out to txt file, I know there is sys.column for table to get table columns name. but i cant find any view column name.

    Thanks for the help!

  2. #2
    Join Date
    Dec 2012
    Posts
    6
    thanks guy! i just found a way doing it. cheers and happy new year !

  3. #3
    Join Date
    Aug 2003
    Posts
    43

    available in syscolumns

    Similar to table columns list, the views columns list also available in syscolumns table.
    Did you find any other way?

Posting Permissions

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