av一区二区在线观看_亚洲男人的天堂网站_日韩亚洲视频_在线成人免费_欧美日韩精品免费观看视频_久草视

您的位置:首頁(yè)技術(shù)文章
文章詳情頁(yè)

SQL Server中搜索特定的對(duì)象

瀏覽:18日期:2023-03-06 14:25:25

一、注釋中帶某關(guān)鍵字的對(duì)象(sys.extended_properties)

主要用到 sys.tables 、sys.columns 、sys.procedures 系統(tǒng)對(duì)象表以及sys.extended_properties 擴(kuò)展屬性表

--查詢列SELECT  A.name AS table_name , B.name AS column_name , C.value AS column_descriptionFROM    sys.tables A INNER JOIN sys.columns B ON B.object_id = A.object_id LEFT JOIN sys.extended_properties C ON C.major_id = B.object_idAND C.minor_id = B.column_id WHERE   CAST(C.[value] AS VARCHAR(1000)) LIKE "%年假%";--查詢表SELECT  A.name AS table_name , C.value AS column_description FROM    sys.tables A INNER JOIN sys.extended_properties C ON C.major_id = A.object_idAND C.minor_id = 0 WHERE   CAST(C.[value] AS VARCHAR(1000)) LIKE "%請(qǐng)假%"--查詢存儲(chǔ)過(guò)程SELECT  A.name AS table_name , C.value AS column_description FROM    sys.procedures A INNER JOIN sys.extended_properties C ON C.major_id = A.object_idAND C.minor_id = 0 WHERE   CAST(C.[value] AS VARCHAR(1000)) LIKE "%年假%"

二、定義語(yǔ)句中帶某關(guān)鍵字的對(duì)象(sys.all_sql_modules )

主要用到 dbo.sysobjects 系統(tǒng)對(duì)象表以及sys.all_sql_modules 對(duì)象定義語(yǔ)句表

--老方式SELECT   DISTINCT b.name, b.xtypeFROM     dbo.syscomments a, dbo.sysobjects bWHERE    a.id = b.id AND b.xtype = "p" AND a.text LIKE "%LotMax%"ORDER BY name;--從 2008 開(kāi)始,新方式SELECT   name, type_descFROM     sys.all_sql_modules s INNER JOIN sys.all_objects o ON s.object_id = o.object_idWHERE    definition LIKE "%LotMax%"ORDER BY type_desc, name;

三、查找列名

select   A.name as table_name, B.name as column_namefrom     sys.tables A inner join sys.columns B on B.object_id = A.object_idwhere    B.name like "%File%" order by A.name, B.name;

完整的列屬性:

with indexCTEas ( select ic.column_id, ic.index_column_id, ic.object_id     from   ZSOtherData.sys.indexes idx    inner join ZSOtherData.sys.index_columns ic on idx.index_id = ic.index_id and idx.object_id = ic.object_id     where  idx.object_id = object_id("MouldTestResultDetail") and idx.is_primary_key = 1 )select   colm.column_id ColumnID, cast(case when indexCTE.column_id is null then 0 else 1 end as bit) IsPrimaryKey, colm.name column_name ,object_definition(colm.default_object_id) AS column_def, systype.name type_name, colm.is_identity is_identity,f.keyno as is_foreignkey, colm.is_nullable , cast(colm.max_length as int) ByteLength , ( case when systype.name = "nvarchar" and colm.max_length > 0 then colm.max_length / 2when systype.name = "nchar" and colm.max_length > 0 then colm.max_length / 2when systype.name = "ntext" and colm.max_length > 0 then colm.max_length / 2 else colm.max_length end ) length , cast(colm.precision as int) precision, cast(colm.scale as int) scale,colm.is_computed, prop.value Remarkfrom     ZSOtherData.sys.columns colm inner join ZSOtherData.sys.types systype on colm.system_type_id = systype.system_type_id and colm.user_type_id = systype.user_type_id left join ZSOtherData.sys.extended_properties prop on colm.object_id = prop.major_id and colm.column_id = prop.minor_id left join indexCTE on colm.column_id = indexCTE.column_id and colm.object_id = indexCTE.object_id     left join sysforeignkeys f on f.fkeyid=colm.object_id and f.fkey=colm.column_idwhere    colm.object_id = object_id("MouldTestResultDetail")order by colm.column_id;

到此這篇關(guān)于SQL Server搜索特定對(duì)象的文章就介紹到這了。希望對(duì)大家的學(xué)習(xí)有所幫助,也希望大家多多支持。

標(biāo)簽: MsSQL
相關(guān)文章:
主站蜘蛛池模板: 国产亚洲精品精品国产亚洲综合 | 特级一级黄色片 | 成人教育av| av免费观看网站 | 成人在线免费网站 | 国产在线视频网 | 99成人| 亚洲一区二区久久 | 精品久久国产 | 日韩在线免费视频 | 久草福利 | 成人亚洲一区 | 日本一区二区三区精品视频 | 亚洲永久精品国产 | 久久99精品久久久久婷婷 | 99精品免费久久久久久日本 | 毛片免费看 | 日本在线网站 | 日韩成人在线观看 | 极品粉嫩国产48尤物在线播放 | 亚州午夜精品 | 狠狠av| 欧美999 | 91精品一区二区三区久久久久久 | 大象一区 | 日本一区二区不卡 | 亚洲一区二区av | 黄a免费网络 | 国产欧美一区二区精品忘忧草 | 欧美一区二区三区视频 | 免费av在线 | 欧美一区免费 | 在线观看中文字幕一区二区 | 亚洲精品视频免费 | 中文字幕亚洲欧美 | 中文字幕成人免费视频 | a级在线免费 | 亚洲一区二区三区四区五区中文 | 国产高清视频在线观看 | 黄色一级大片在线观看 | 在线三级电影 |