Have you failed a job interview?
Send us your job interview questions and get correct answers.

Using SSMS, where do you find the list of all tables within a database?

Experience Level: Junior
Tags: DatabasesMS SQL ServerQuality Assurance (QA)

Answer

  • Connect to the MS SQL Server instance using SSMS, you will see the Object Explorer on the left-hand side.
  • Expand the node Databases, list of all databases will appear.
  • Then expand the database you are interested in and expand the node Tables. Under this node you will find all tables that exist in the database.

Comments

No Comments Yet.
Be the first to tell us what you think.
MS SQL Server for Testers
MS SQL Server for Testers

Are you learning Databases ? Try our test we designed to help you progress faster.

Test yourself