How can I get column names from a table in SQL?

Forums SQLHow can I get column names from a table in SQL?
Staff asked 7 months ago

Answers (1)

Add Answer
Umang Ramani Marked As Accepted
Staff answered 7 months ago

Try this one :

SELECT column_name
FROM   information_schema.columns
WHERE  table_name = '{{Your Table name}}'

 

And In SSMS you can use the shortcut for it you need to select the table name and press “Alt+F1”

Subscribe

Select Categories