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 vote325 views1 answer
Concat column value of same user in mysql
SQL
0 vote362 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote349 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote324 views1 answer
Low level operator in dbms
SQL
1 vote337 views1 answer
Mysql tables max count
SQL
0 vote328 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote356 views1 answer
Sql sum if
SQL
0 vote323 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote351 views1 answer
Mysql wait_timeout
SQL
4 votes327 views1 answer
Adding data to table in sql python
SQL