sqlserver常用系统表及sql语句

--数据库

select [name] from sysdatabases

--表、视图、存储过程

select [name] from sysObjects where (xtype='V' or xtype='P' or xtype='U')and [name]<>'dtproperties'and status> =0 order by [name]

--某表的字段和类型

Select a.name as ColumnName,b.name as TypeName from syscolumns a, systypes b, sysObjects c where a.xtype = b.xusertype and a.id = c.id and c.name='dic_cakeshop_caketype' order by a.colorder

--存储过程字段和类型

Select a.name as ColumnName,a.isoutparam as isoutparam,b.name as TypeName from syscolumns a, systypes b, sysObjects c where a.xtype = b.xusertype and a.id = c.id and c.name='AddNewSms' order by a.colorder