当前位置: 数据库>sqlserver
查询数据库内容的几个sql
来源: 互联网 发布时间：2014-08-29
本文导语: 收集了一些菜鸟级别的查询数据库内容的sql，供初学者参考。 表 代码如下: SELECT name as TableName FROM SYS.tables 存储过程 代码如下: SELECT P.name AS SpName,M.definition AS SpText FROM SYS.procedures AS P JOIN SYS.sql_modules AS M ON P.object_id =M.obj...
收集了一些菜鸟级别的查询数据库内容的sql，供初学者参考。
表
代码如下:
SELECT name as TableName FROM SYS.tables
存储过程
代码如下:
SELECT P.name AS SpName,M.definition AS SpText FROM SYS.procedures AS P
JOIN SYS.sql_modules AS M ON P.object_id =M.object_id
JOIN SYS.sql_modules AS M ON P.object_id =M.object_id
函数
代码如下:
SELECT F.name AS FunName,M.definition AS FunText FROM SYS.all_objects AS F
JOIN SYS.sql_modules AS M ON F.object_id =M.object_id WHERE F.type IN ('tf','if','fn')
JOIN SYS.sql_modules AS M ON F.object_id =M.object_id WHERE F.type IN ('tf','if','fn')
视图
代码如下:
SELECT V.name AS ViewName,M.definition AS ViewText FROM SYS.all_objects AS V
JOIN SYS.sql_modules AS M ON V.object_id =M.object_id WHERE V.type='v'
JOIN SYS.sql_modules AS M ON V.object_id =M.object_id WHERE V.type='v'
触发器
代码如下:
SELECT Tr.name AS TriggerName,M.definition AS TriggerText FROM SYS.triggers AS Tr
JOIN SYS.sql_modules AS M ON Tr.object_id=M.object_id
JOIN SYS.sql_modules AS M ON Tr.object_id=M.object_id
表字段类型
代码如下:
SELECT C.name AS ColumnName,Ty.name AS ColumnType FROM SYS.tables AS Tb
JOIN SYS.columns AS C ON Tb.object_id=C.object_id
JOIN SYS.types AS Ty ON C.system_type_id=Ty.system_type_id WHERE Tb.name='test1'
JOIN SYS.columns AS C ON Tb.object_id=C.object_id
JOIN SYS.types AS Ty ON C.system_type_id=Ty.system_type_id WHERE Tb.name='test1'
您可能感兴趣的文章:
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。