Data Dictionary in SQL Server

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