MySQL Forums :: Microsoft SQL Server :: "SHOW Columns FROM table" in MSSQL?
Re: "SHOW Columns FROM table" in MSSQL?
Posted by: Roland Bouman ()
Date: March 23, 2006 08:27AM
just do a select on the information_schema.COLUMNS table:
select column_name
from <dbname>.information_schema.columns
where table_name = '<tablename>'
see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_4pbn.asp
select column_name
from <dbname>.information_schema.columns
where table_name = '<tablename>'
see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_4pbn.asp
| Subject | Written By | Posted |
|---|---|---|
| "SHOW Columns FROM table" in MSSQL? | Steve Yego | 03/21/2006 02:06PM |
| Re: "SHOW Columns FROM table" in MSSQL? | Roland Bouman | 03/23/2006 08:27AM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates