[SQLServer]查看表结构

sp_columns itm_itemsp_help itm_itemsp_helpconstraint itm_itemselect * from INFORMATION_SCHEMA.COLUMNS where table_name = 'itm_item'select * from sysconstraints where id=object_id('itm_item') and (status &1)=1