摘要： select * from sys.extended_properties where major_id in (select id from sysobjects where name = 't_lotteryTogether' )查看表注释信息sp_mshelpcolumns 'dbo.t_websiteNotice'查看列信息sELECT syscolumns.name,systypes.name,syscolumns.isnullable, syscolumns.length FROM syscolumns, systypes WHERE syscolu 阅读全文