资源描述:
《砼浇注施工高处坠落预防专项措施》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、=quotename(@table_owner)endelsebeginSELECT@full_table_name=quotename(@table_owner)+'.'+quotename(@table_name)endend/*GetObjectID*/SELECT@table_id=object_id(@full_table_name)selectTABLE_QUALIFIER=convert(sysname,db_name()),TABLE_OWNER=convert(sysname,user_name(o.uid)),TABLE_NAME=convert(s
2、ysname,o.name),COLUMN_NAME=convert(sysname,c.name),KEY_SEQ=casewhenc.name=index_col(@full_table_name,i.indid,1)thenconvert(smallint,1)whenc.name=index_col(@full_table_name,i.indid,2)thenconvert(smallint,2)whenc.name=index_col(@full_table_name,i.indid,3)thenconvert(smallint,3)whenc.name=i
3、ndex_col(@full_table_name,i.indid,4)thenconvert(smallint,4)whenc.name=index_col(@full_table_name,i.indid,5)thenconvert(smallint,5)whenc.name=index_col(@full_table_name,i.indid,6)thenconvert(smallint,6)whenc.name=index_col(@full_table_name,i.indid,7)thenconvert(smallint,7)whenc.name=index
4、_col(@full_table_name,i.indid,8)thenconvert(smallint,8)whenc.name=index_col(@full_table_name,i.indid,9)thenconvert(smallint,9)whenc.name=index_col(@full_table_name,i.indid,10)thenconvert(smallint,10)whenc.name=index_col(@full_table_name,i.indid,11)thenconvert(smallint,11)whenc.name=index
5、_col(@full_table_name,i.indid,12)thenconvert(smallint,12)whenc.name=index_col(@full_table_name,i.indid,13)thenconvert(smallint,13)whenc.name=index_col(@full_table_name,i.indid,14)thenconvert(smallint,14)whenc.name=index_col(@full_table_name,i.indid,15)thenconvert(smallint,15)whenc.name=i
6、ndex_col(@full_table_name,i.indid,16)thenconvert(smallint,16)end,PK_NAME=convert(sysname,i.name)fromsysindexesi,syscolumnsc,sysobjectso--,syscolumnsc1whereo.id=@table_idando.id=c.idando.id=i.idand(i.status&0x800)=0x800and(c.name=index_col(@full_table_name,i.indid,1)orc.name=index_col(@fu
7、ll_table_name,i.indid,2)orc.name=index_col(@full_table_name,i.indid,3)orc.name=index_col(@full_table_name,i.indid,4)orc.name=index_col(@full_table_name,i.indid,5)orc.name=index_col(@full_table_name,i.indid,6)orc.name=index_col(@full_table_name,i.indid,7)orc.name=index_col