方法一:sp_help 'table_name '
例 如: exec sp_help 't_mrp_computebill'
方法二:INFORMATION_SCHEMA.COLUMNS
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'T_MRP_COMPUTEBILL'
方法一:sp_help 'table_name '
例 如: exec sp_help 't_mrp_computebill'
方法二:INFORMATION_SCHEMA.COLUMNS
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'T_MRP_COMPUTEBILL'