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 vote208 views1 answer
Trigger in postgresql to change incoming entry
SQL
2 votes221 views1 answer
Oracle block
SQL
3 votes199 views4 answers
Mysql create table from select statement
SQL
0 vote191 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
3 votes192 views1 answer
Index using in query plsql
SQL
0 vote211 views1 answer
Mysql dump everythign
SQL
3 votes218 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote237 views1 answer
Sql show founctions
SQL
1 vote259 views1 answer
Hangfire clear all jobs
SQL
0 vote207 views1 answer
Tsql cmd exec script from file
SQL