Skip to content
Advertisement

Invalid object name in SQL Management Studio

I’ve been creating a database for class and I’m having trouble seeing my tables. I have a total of 12 tables I have created, 3 via CREATE TABLE statements and the rest using the SQL Server Management Studio, I’m trying to enter an INSERT INTO statement but it’s not recognizing the table that I have created.

enter image description here

enter image description here

Here are some screenshots with what I’m working with.

Advertisement

Answer

First refresh the Tables in your database to check whether that table existed or not.

If it does exist, check your SQL connection on your current session, make sure you are connecting to the correct server instance.

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement