[SQLServer]查看表构造

[SQLServer]查看表结构sp_columns itm_itemsp_help itm_itemsp_helpconstraint itm_itemselect * from INF

[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