SQL Server- Get all column names in the table

Question

I have a table name as 'tblOrder', having three columns. I would like to print the column names.

I want a script that should return a result as:

OrderId Name OrderTrackingNo

Answer 1

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('tblOrder')

Try this