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 vote321 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote319 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
3 votes475 views9 answers
Linq to sql converter online
SQL
-1 vote315 views1 answer
Ssms connect with connection string
SQL
1 vote565 views1 answer
Postgres convert text to number
SQL
0 vote341 views1 answer
Express api ith mysql data
SQL
0 vote360 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote339 views1 answer
Oracle list of long running queries
SQL
2 votes315 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote342 views1 answer
Hackerrank sql test solutions
SQL