Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

MSSQL Interview Questions and Answers

Ques. How To Get a List of All Tables with "sys.tables" View in MS SQL Server?
Ans. 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.
Is it helpful? Yes No

Most helpful rated by users:

©2020 WithoutBook