How to get MSSQL's tables, view and column information.

We can take a look at MS-SQL's the tables, the views and the columns by below sql query.

1 2 3 4 5 6 7 8

-- Tables Information SELECT * FROM INFORMATION_SCHEMA.TABLES -- View Information SELECT * FROM INFORMATION_SCHEMA.VIEWS -- Column Information SELECT * FROM INFORMATION_SCHEMA.COLUMNS