SQL query to return column names

• disridha

  SSC Rookie

  Points: 37

  More actions

  December 22, 2003 at 8:37 pm

  #64895

  Hi there,

  Is there an SQL query which retrieves the column names of a table?

  Ex: For table Emp, there are cols -- Eno,EName,ESalary.

  So, is there a query which I can run on the table Emp so as to retrieve the column names of this table as Eno,EName,ESalary.

  Any inputs are welcome. Thanks in advance

• Ferguson

  SSCertifiable

  Points: 5837

  More actions

  December 22, 2003 at 8:55 pm

  #487539

  Example: (change table name from 'Title' to whatever you want)

  select sc.name

  from sysobjects so

  inner join syscolumns sc on sc.id=so.id

  where so.type='U' and so.name = 'Title'