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 vote266 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote244 views1 answer
SQL Server modify_timestamp trigger
SQL
1 vote288 views1 answer
Mysql find most common value
SQL
0 vote249 views1 answer
Change schema of all tables postgres
SQL
1 vote263 views1 answer
Sql insert for each distinct value
SQL
0 vote297 views1 answer
Show all sequences postgres
SQL
16 votes258 views1 answer
Mssql int max value
SQL
32 votes262 views6 answers
Insert into values select
SQL
23 votes279 views4 answers
How to show all users in mysql
SQL
0 vote259 views1 answer
What alter does in db
SQL