January 9, 2013

Select columns as rows from table

To select column as row from table in SQL Server, use this code

---------------------
SQL QUERY :
---------------------


SELECT     t.name AS table_name, 
           SCHEMA_NAME(schema_id) AS schema_name,
           c.name AS column_name
FROM       sys.tables AS t
INNER JOIN sys.columns c 
               ON t.OBJECT_ID = c.OBJECT_ID
WHERE      t.name = 'Test'
ORDER BY   schema_name, table_name;



-----------------------------------
SQL QUERY OUTPUT :
-----------------------------------


Test     dbo TestId
Test     dbo NameTitle
Test     dbo NormalValues