獲取表的結構數據

在動態編程中，我們需要獲取表的結構數據，如表名，數據類型，精度等數據。你可以參考下麵幾行代碼：

DECLARE @table_Name SYSNAME = 'Q'


SELECT t.TABLE_NAME, 
       c.COLUMN_NAME, 
       c.DATA_TYPE, 
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       ISNULL(CHARACTER_MAXIMUM_LENGTH,0 ) AS SIZE
FROM INFORMATION_SCHEMA.TABLES AS t
INNER JOIN INFORMATION_SCHEMA.COLUMNS c ON 
    (t.TABLE_NAME = c.TABLE_NAME) 
WHERE t.TABLE_NAME= @table_Name
ORDER BY t.TABLE_NAME