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.

--数据库

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

总结

以上是内存溢出为你收集整理的sqlserver常用系统表及sql语句全部内容，希望文章能够帮你解决sqlserver常用系统表及sql语句所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。