Getting the columns

[M J Jaya Chitra]

Can anyone tell me how to retrieve the column names in a table?

Best Regards, M. J. Jaya Chitra

[Giorgi Dalakishvili]

If you are using sql server then you can use the following query: SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'name_of_the_table'

#region signature my articles #endregion

[r a j u u]

ist working? i tried this query but its saying Invalid columnname...

Rajendran

[Giorgi Dalakishvili]

Yes, it is. Just make sure you are performing the query against the database that contains your table

#region signature my articles #endregion

[r a j u u]

In SQL, Assume columnname- id(It should be identity and autoincrement),Name then you will try this query select name from tablename where id=0

Rajendran

[Krish KP]

In MS SQL Server syscolumns table holds column names and sysobjects table names. SELECT * FROM syscolumns co INNER JOIN sysobjects so ON co.id = so.id WHERE so.name = 'mytable'

Regards KP

[M J Jaya Chitra]

Thanks a lot. It is working fine.

Best Regards, M. J. Jaya Chitra

[Giorgi Dalakishvili]

You are welcome :)

#region signature my articles #endregion

[Senu Gandhi]

Hi Jaya, For a simple solution try this sp_help '' Senthil

[joemonvarghese]

hi try this qry select name from syscolumns where id= (select id from sysobjects where name=)