note 65988 added to function.mssql-fetch-field

For really detailed table information, use syscolumns, like this: SELECT c.name, c.prec, c.scale, t.name type FROM syscolumns c, systypes t, sysobjects o WHERE o.name = 'yourtablename' AND o.id = c.id AND c.xtype = t.xtype For other properties see the MS SQL online help. Search for 'syscolumns'. Or an another solution: sp_columns @table_name = 'yourtablename', @column_name = 'thecolumnname' //no "select ..." !!!! This gives info about only the specified column. ---- Server IP: 195.228.154.4 Probable Submitter: 82.131.219.115 ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-fetch-field.php Edit -- http://master.php.net/note/edit/65988 Del: integrated -- http://master.php.net/note/delete/65988/integrated Del: useless -- http://master.php.net/note/delete/65988/useless Del: bad code -- http://master.php.net/note/delete/65988/bad+code Del: spam -- http://master.php.net/note/delete/65988/spam Del: non-english -- http://master.php.net/note/delete/65988/non-english Del: in docs -- http://master.php.net/note/delete/65988/in+docs Del: other reasons-- http://master.php.net/note/delete/65988 Reject -- http://master.php.net/note/reject/65988 Search -- http://master.php.net/manage/user-notes.php