Get all columns of specific table 29 April 2014 Admin Tuesday, April 29, 2014 6:09:00 PM Today I needed to get all columns of specifict table. SQL which you can use for this purpose is the following: SELECT COLUMN_NAME 'All_Columns' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Specific table'