Azure Data Studio-Invalid object name

Question

After I import my data into the database, and it has appeared on the left hand side, I did my query, and it came up with a message 'Invalid Object Name'. Couldn't know how to solve the problem.

Answer 1

To refresh the IntelliSense cache in ADS, press SHIFT+CTRL+P, begin typing "IntelliSense", and click "Refresh IntelliSense Cache" when it appears in the list.

To make quick work of this forward, you can assign a keybinding by clicking the gear icon to the right of the "Refresh IntelliSense Cache" entry and entering a key stroke combination.

Separately, your screen image shows the newly imported tables were created in the master system database. I suggest you create a user database for this purpose as that will isolate the tables from system objects and facilitate promoting your database schema later. Run the T-SQL command below in a query window to create a new user database with name of your choosing and create/import your tables into that database.

CREATE DATABASE YourDatabaseName;