自動(dòng)列出在tmstamp上所缺失索引的創(chuàng)建語句

發(fā)布時(shí)間：2020-08-10 06:28:27 來源：ITPUB博客閱讀：216 作者：o0yuki0o 欄目：關(guān)系型數(shù)據(jù)庫

SELECT o.name,user_name(o.uid),'ALTER TABLE [dbo].'+'['+object_name(co.id) /*tbname*/+']'+' ADD CONSTRAINT [TM_UNIQUE_'+''+upper(object_name(co.id))+'] UNIQUE NONCLUSTERED ('+upper(co.name) /*colname*/+' ASC)'
FROM syscolumns co
inner join sysobjects o
on co.id=o.id and o.xtype='U' and o.name<>'dtproperties'
WHERE co.name='TMSTAMP' and user_name(o.uid)='dbo' --order by o.name
and object_name(co.id) not in (
select tab.Name as Tab_Name
from sys.indexes ind
inner join sys.tables tab on ind.Object_id = tab.object_id and ind.type in (1,2)
inner join sys.index_columns index_columns on tab.object_id = index_columns.object_id and ind.index_id = index_columns.index_id
inner join sys.columns Col on tab.object_id = Col.object_id and index_columns.column_id = Col.column_id
left join sysobjects o on tab.name=o.name and o.type='U'
where Col.Name='TMSTAMP' and user_name(o.uid)='dbo' --order by tab.name
) order by object_name(co.id)

向AI問一下細(xì)節(jié)

自動(dòng)列出在tmstamp上所缺失索引的創(chuàng)建語句

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽