MSSQL-查詢table欄位型態

查詢table欄位型態

/* dbo.sysobjects 資料表 (name資料表名 id資料表代碼 )

   dbo.syscolumns 欄位 (name欄位名 id資料表代碼 prec長度 isnullable空值)

   dbo.systypes  型態 (name型態明 ) */

select syscolumns.name,syscolumns.prec,syscolumns.isnullable,systypes.name from syscolumns

join systypes on syscolumns.xusertype = systypes.xusertype

--where id = (select id from sysobjects where name='SMXCAAA')

where id = OBJECT_ID('SMXCAAA')

order by offset desc