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

8 votes163 views4 answers
Reset SQL auto increment
SQL
1 vote158 views1 answer
How to delay stored procedure execution in sql server
SQL
1 vote134 views1 answer
Truncate left characters mysql
SQL
0 vote144 views1 answer
How to add timestamp column in mysql
SQL
53 votes336 views6 answers
How to install mysql ubuntu
SQL
0 vote142 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote139 views1 answer
Mysql terminal list table
SQL
0 vote128 views1 answer
Mysql with
SQL
0 vote140 views1 answer
Drop-toys-table
SQL
6 votes141 views1 answer
Postgres get size of database
SQL