In this article we will show you, How to write a SQL Query to Get Column Names From Table in SQL Server with example. This is one of the common SQL Interview Question that you might face in the interviews. For this example, We are going to use the below shown data
Above screenshot will show you the data inside the NewCustomer table present in the SQL Tutorial database.
Get Column Names From Table in SQL Server Example 1
In this example we will show you, How to Get Column names in SQL Server using INFORMATION_SCHEMA.
T-SQL CODE
|
1 2 3 4 5 6 |
-- Query to Get Column Names From Table in SQL Server USE [SQL Tutorial] GO SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'NewCustomers' |
OUTPUT
You can use the below query to get all the information about the Table
T-SQL CODE
|
1 2 3 4 5 6 |
-- Query to Get Column Names From Table in SQL Server USE [SQL Tutorial] GO SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'NewCustomers' |
OUTPUT
Get Column Names From Table in SQL Server Example 2
In this example we will show you, How to Get Column names in SQL Server using sys.columns.
T-SQL CODE
|
1 2 3 4 5 6 |
-- Query to Get Column Names From Table in SQL Server USE [SQL Tutorial] GO SELECT name FROM sys.columns WHERE OBJECT_ID = OBJECT_ID('NewCustomers') |
OUTPUT
Let me show you what will happen, if we replace the name column with *
T-SQL CODE
|
1 2 3 4 5 6 |
-- Query to Get Column Names in SQL Server USE [SQL Tutorial] GO SELECT * FROM sys.columns WHERE OBJECT_ID = OBJECT_ID('NewCustomers') |
OUTPUT
Thank You for Visiting Our Blog
Leave a Reply