column names

SQL Server – How to get all Column names of a table

  • by

To get Column names of a table in SQL server use query below query: Select COLUMN_NAME,DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=’Your_Table_Name’ For example: we will consider… Read More »SQL Server – How to get all Column names of a table