To get the Table in information in SQL Server, we can use below Query:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Users' ORDER BY ORDINAL_POSITION
Where’ Users’ is Table Name
Output is shown in below snap:
![SQL Server INFORMATION_SCHEMA.COLUMNS SQL Server INFORMATION_SCHEMA.COLUMNS](https://i0.wp.com/jitendrazaa.com/blog/wp-content/uploads/2010/09/SQL-Server-INFORMATION_SCHEMA.COLUMNS-300x44.jpg?resize=300%2C44&ssl=1)
We can use below query also:
sp_Columns 'Users'
Output is shown in below image:
![sp_Columns SQL Server sp_Columns SQL Server](https://i0.wp.com/jitendrazaa.com/blog/wp-content/uploads/2010/09/sp_Columns-SQL-Server-300x42.jpg?resize=300%2C42&ssl=1)
Leave a Reply