摘要:
方法一:create proc ssasset nocount oncreate table TableSpace( TableName varchar(50), RowsCount char(11), Reserved varchar(18), Data varchar(18), Index_size varchar(18), Unused varchar(18) )declare @sql varchar(500)declare @TableName varchar(50)DECLARE @ObjOwner varchar(50)declare Cursor1 Cursorfor ... 阅读全文
摘要:
create table #tempindex(tableName nvarchar(776),index_name sysname,index_description varchar(2000),index_keys varchar(2000))exec sp_msforeachtable 'insert into #tempindex(index_name,index_description,index_keys) exec sp_helpindex ''?'';update #tempindex set tableName=''?& 阅读全文