Get primary key from table name DECLARE @tableName varchar(50) select @tableName = ‘@tablename’ — exclude schema SELECT [name] as primarykeyname FROM syscolumns WHERE [id] IN ( SELECT [id] FROM sysobjects WHERE [name] = (@tableName)) AND colid IN (SELECT SIK.colid FROM sysindexkeys SIK JOIN sysobjects SO ON SIK.[id] = SO.[id] WHERE SIK.indid = 1 AND SO.[name] [...]
–get column info like column name and column type SELECT Table_Schema, Table_Name, Column_Name, Data_Type FROM information_schema.columns WHERE table_name in ( select name from hha..sysobjects where xtype = ‘V’ and name like ‘@objectname’ ) – get table name from field name SELECT Table_Schema, Table_Name, Column_Name, Data_Type FROM information_schema.columns WHERE table_name in ( select name from hha..sysobjects [...]
ALTER SCHEMA destinationschema TRANSFER sourceschema.objectname from http://sql-articles.com/scripts/change-transfer-schema-for-all-objects/
