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:
We can use below query also:
sp_Columns 'Users'
Output is shown in below image:
Leave a Reply