Tables won't appear as selectable object after creating it

SELECT *
FROM EmployeeDemographics


Msg 208, Level 16, State 1, Line 2

Invalid object name 'EmployeeDemographics'.

I'm currenlty watching Alex the Analyst's SQL tutorial and everytime I create a table, close, and restart SQL, the table is not found by SQL. When I use a statement such as FROM the table doesn't appear in the list of selectable objects. When I type it manually, the table_name has red lines under it indicating that it's an invalid object name. When I run the code I get the error message above. I tried refreshing the database and the Intellisense to no avail. Let me know if I should post the code for the table and thanks in advanced.

1 answer

  • answered 2022-05-07 03:55 alan503

    Turns out I wasn't connected to the right database, which I can change in the top right corner. The tutorial explains it at the end.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum