MSSQL%20Interview%20Questions%20and%20Answers

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

Answer: 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
wb USER_TABLE 2007-05-19 23:05:43.700

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