In sql server information about all the columns and its properties of a table is stored in the system view sys.Columns.
Suppose we have created a table in sql server by following query:
CREATE TABLE Student(
Roll_No BIGINT IDENTITY,
Sql query to get the all the columns name of table Student
WHERE object_id = OBJECT_ID('Student')