"sys.tables" - Getting a List of All Tables in SQL Server


How To Get a List of All Tables with "sys.tables" View in SQL Server?

✍: FYIcenter.com


If you want to see the table you have just created, you can use the "sys.tables" system view to get a list of all tables in the current database. The tutorial script gives you a good example:

SELECT name, type_desc, create_date FROM sys.tables
name    type_desc       create_date
tip     USER_TABLE      2007-05-19 23:05:43.700

The output shows that there is only one table in the current database.


"sys.columns" - Getting a List of Columns in a Table in SQL Server

CREATE TABLE - Creating New Tables in SQL Server

Managing Tables and Columns in SQL Server

⇑⇑ SQL Server Database Tutorials

2018-03-29, 3303🔥, 1💬