Get table column names sql ssms

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Your Table Name'
ORDER BY COLUMN_NAME

-- IS_NULLABLE returns yes or no depending on null or not null

Source: aspsnippets.com

Similar codes

4 votes116 views3 answers
Mysql varchar length
SQL
0 vote126 views1 answer
Mysql workbench view
SQL
1 vote122 views2 answers
Mysql show views
SQL
2 votes124 views1 answer
SELECT INTO
SQL
0 vote114 views1 answer
Difference between cross apply and inner join
SQL
0 vote132 views2 answers
How to save result of sqlite query in a table
SQL
0 vote116 views1 answer
Running query in redshift
SQL
2 votes133 views3 answers
Mysql list tables by size
SQL
1 vote118 views1 answer
Oracle lock user
SQL
0 vote117 views1 answer
Oracle DROP PROGRAM
SQL