[Get columns list SQLserver] Get table's column in sql server #SQLServer

query.sqlsrv

SELECT c.name 'Column Name' 
FROM sys.columns c
INNER JOIN  sys.types t ON c.user_type_id = t.user_type_id
LEFT OUTER JOIN 
sys.index_columns ic ON ic.object_id = c.object_id AND ic.column_id = c.column_id
LEFT OUTER JOIN 
sys.indexes i ON ic.object_id = i.object_id AND ic.index_id = i.index_id
WHERE
c.object_id = OBJECT_ID('YOUR_TABLE_NAME')