Tuesday, September 7, 2010

Data Dictionary in SQL Server

--STEP : 1

SELECT * INTO JAHNAVI FROM
(select ROW_NUMBER() OVER (ORDER BY name) As SrNo, name ,'' AS 'Column Name','' AS 'Data Type' ,'' AS 'Maximum Length' from sysobjects where xtype = 'u'
UNION ALL
SELECT '' As SrNo, table_name + '$$$$', column_name 'Column Name', data_type 'Data Type', CHARacter_maximum_length 'Maximum Length'
FROM information_schema.columns
WHERE table_name in (select name from sysobjects where xtype = 'u')
)A
ORDER BY A.NAME


--STEP : 2

UPDATE JAHNAVI
SET NAME = ''
WHERE NAME LIKE '%$$$$'

--STEP : 3
SELECT * FROM JAHNAVI

No comments:

Post a Comment