In this article we will learn about some of the mostly used SQL Server queries every developer should know. These queries can be asked you as an Interview Question or they are handy for you in your day to day tasks.
In this query we will learn about How to get all column names from Sql Server table.
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='TableName';