Getting all columns from SQL Table

select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='TableName'