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

monika gabani Apr 23, 2022 0 187

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

Staff asked 2 years ago

1 Vote Up Vote Down

Umang Ramani Marked As Accepted

Staff answered 2 years 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”

monika gabani