Introduction
The following script will give table column names as rows. Treat the table name as User
:
SELECT COLUMN_NAME 'All_Columns' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='User'
Following is the result:
History
- May 03, 2012: Article created