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.

That depends on which DBMS you are using. This is the according to the SQL standard


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