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,sysObjects c where a.xtype = b.xusertype and a.id = c.id and c.name='AddNewSms' order by a.colorder

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!