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.
Related Databases job interview questions
How do you retrieve and show all rows from the table in Microsoft SQL Server database using Microsoft SQL Server Management Studio (SSMS)?
DatabasesQuality Assurance (QA) JuniorHow do you create a table in Microsoft SQL Server database?
DatabasesQuality Assurance (QA) JuniorWhere do you find a list of databases on the SQL Server?
DatabasesQuality Assurance (QA) JuniorWhat is a data type?
DatabasesQuality Assurance (QA) JuniorDo you know what is a database, table and what is the difference between them?
DatabasesQuality Assurance (QA) Junior
