1) Write dynamic query for rename table name 
        For each table use sp_rename procedure
           --change Table name 
           EXEC sp_RENAME '[OldTableName]' , '[NewTableName]'
2) Get column names which are ending with _skey, then 
          --change Column name 
          EXEC sp_RENAME 'TableName.[OldColumnName]', '[NewColumnName]', 'COLUMN'

3) ALTER TABLE command for changing column data type

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES -- Table Names
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE		-- Column name which have _skey as ending tag
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%@_skey' ESCAPE '@'

SELECT TABLE_NAME, COLUMN_NAME   -- Data type dec(18,0) columns
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE = 'decimal'
	AND NUMERIC_PRECISION = 18 
	AND NUMERIC_SCALE = 0

quote:

---

Originally posted by shanmugaraj

Ok thanks
THANKS
SHANMUGARAJ
nshanmugaraj@gmail.com

---