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

0 vote179 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
15 votes168 views4 answers
How to get all tables in sql
SQL
11 votes165 views1 answer
Mysql order by two columns priority
SQL
12 votes177 views4 answers
Mysql version query
SQL
0 vote185 views1 answer
Mysql group by range
SQL
42 votes247 views6 answers
Install beautifulsoup
SQL
0 vote216 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote163 views2 answers
Insert into
SQL
5 votes241 views2 answers
Add days in oracle sql
SQL
0 vote163 views2 answers
Update information in a mysql column
SQL