Answers

Question and Answer:

  Home  MS SQL Server

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

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

GO

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.

 133 views

More Questions for you: