摘要:
如题:分享一个SQL数据库脚本记录生成器可以生成表结构脚本下载地址 阅读全文
摘要:
--删除某字段的所有关系DECLARE @tbname SYSNAME , @fdname SYSNAMESELECT @tbname = 't' --要处理的表名 , @fdname = 'a' --要处理的字段名--定义删除处理的语句DECLARE tb CURSOR local FOR--默认值约束SELECT sql='alter table ['+b.name+'] drop constraint ['+d.name+']'FROM syscolumns aJOIN sysobjects b ON a.i 阅读全文
摘要:
SELECT sysobjects.id objectId , OBJECT_NAME(sysobjects.parent_obj) tableName , sysobjects.name constraintName , sysobjects.xtype AS constraintType , syscolumns.name AS columnNameFROM sysobjects INNER JOIN sysconstraints ON sysobjects.xtype IN ( 'C', 'F', 'PK', ... 阅读全文
摘要:
SELECT 索引名称 = a.name , 表名 = c.name , 索引字段名 = d.name , 索引字段位置 = d.colidFROM sysindexes a JOIN sysindexkeys b ON a.id = b.id AND a.indid = b.indid JOIN sysobjects c ON b.id = c.id JOIN syscolumns d ON b.id = d.id ... 阅读全文