Columns Name

Results 1 to 2 of 2

Thread: Columns Name

  1. #1
    ASP Guest

    Default Columns Name

    Hi,<BR>Does anybody know how I can obtain the columns name of any table in SQL Server 7.0?<BR>Thanks,

  2. #2
    Harish Guest

    Default RE: Columns Name

    Try this<BR><BR>SELECT COLUMN_NAME <BR>from INFORMATION_SCHEMA.COLUMNS<BR>where table_name = &#039;your tablename&#039;<BR><BR>Hope this helps<BR>Harish<BR><BR>

Posting Permissions

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