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

1 vote353 views1 answer
Oracle index partition
SQL
0 vote372 views1 answer
Template MySQL Zabbix agent
SQL
1 vote347 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote350 views1 answer
Oracle synonym procedure dblink
SQL
1 vote406 views2 answers
Intersect sql
SQL
0 vote372 views1 answer
Mysql error 1251
SQL
0 vote306 views1 answer
Oracle function select into
SQL
0 vote380 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote374 views1 answer
Oracle session statistics
SQL
0 vote394 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL