How to return a table's column names?

[yeago]

I am attempting to get the microsoft SQL equivalent of "show columns from table" from MySQL.

HOW?

[Barand]

Here's one way

[code]$result = mssql_query("SELECT TOP 1 * FROM tablename");
$row = mssql_fetch_assoc($result);
foreach ($row as $colname => $value) {
    echo $colname . '<BR />';
}[/code]

[GeoffOs]

You can use a query like this:

[code]select * from information_schema.columns where table_name = '<<your table name>>'[/code]

[fractil]

Continuing with GeoffOs post, I find it helpful to include the database name in the FROM clause.

just do a select on the information_schema.COLUMNS table:

select column_name
from <dbname>.information_schema.columns
where table_name = '<tablename>'

see: [a href=\"http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_4pbn.asp\" target=\"_blank\"]http://msdn.microsoft.com/library/default...._ia-iz_4pbn.asp[/a]

Cheers!