The inability to see tables in an MSSQL database is usually caused by server migration. With Azure Data Studio, you can connect to the server to check the existing tables and perform the necessary operations.
You can follow the steps below to see the tables in the MSSQL database with Azure Data Studio:
Download and Install Azure Data Studio:
Connect to the Server:
- Open Azure Data Studio.
- Click the Connect button in the top left corner.
- Enter your server name, database name and credentials.
- Click the Connect button to establish the connection.
Select the database:
- Click on the Databases section on the left side.
- Find your migrated database and click on it.
View Tables:
- Under the database you selected, expand the Tables folder.
- Here, the list of available tables will be displayed. Double-click on the table you are interested in to view its contents.
View Table Data with Queries:
- If you want to query the data in a particular table, open a new query window.
- You can write a SQL query like the one below:
SELECT * FROM [TableName];
- Press F5 to run the query.
By following these steps, you can view your MSSQL tables with Azure Data Studio.
