If you want to describe table like DESCRIBE in MySQL you can use this:$sql = <<<SQLSELECT column_name,data_type,column_default,is_nullableFROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog=c.table_catalog AND t.table_schema=c.table_schema AND t.table_name=c.table_nameWHERE t.table_name='TABLE-NAME'SQL;

Be aware that this function will only return the first 30 characters of the name of the column. If the actual column name is longer, it will be truncated. This is at least true with the following setup:PHP 4.3.1MSSQL 8.00.760