ansaurus

Question

MS SQL Error "Invalid object name" on table I just created

Answer 1

+4 A:

They don't have the same name though. The one you have created has a 2 suffix.

CREATE TABLE [table_test2]

And

select * from table_test

If you are sure you weren't making a similar error with your select/insert statements I would suggest running the following.

select * from 
sysobjects /*For SQL Server 2000*/
where name like 'table_test%'

Additionally your insert statement looks dodgy. I think you would need square brackets or double quotes not single quotes. I'm not sure if that could produce the error you were seeing.

insert into table_test
([User 4], [User 3], [User 2])
values
('a','b','c')

Martin Smith 2010-07-22 13:32:00

Sorry, copy and paste error. The table names match and I still get the error.The table is found in the sysobject table. Which is sysobjects, not sys.objects.

JSJoy 2010-07-22 13:46:56

@jsjoy - Good point SQL2000 uses sysobjects. What about the square brackets? You definitely can't use single quotes there.

Martin Smith 2010-07-22 13:48:37

yep, that's it. I kept focusing on the fact that it says the table is not found. Silly syntax error. Thanks!

JSJoy 2010-07-22 13:55:40

Answer 2

A:

In your CREATE TABLE statement, the name of the table is table_test2

DoubleJ92 2010-07-22 13:33:01

Sorry, I corrected the post. The table names are the same when I try it.

JSJoy 2010-07-22 13:44:44

Answer 3

A:

Are you certain you are using the correct database? Try using the USE statement right before each, or prefixing the table with the name of the database, for example:

CREATE TABLE mydatabase..table_name  ...
INSERT INTO mydatabase..table_name ...

The '..' prefix can be used so you don't need to specify the schema (e.g. dbo).

Hope that helps.

Kieren Johnstone 2010-07-22 13:49:06

Answer 4

+1 A:

Syntax error. need to wrap the insert statement column list with brackets rather than quotes:

this would be the proper syntax: insert into table_test2 ([User 4], [User 3], [User 2]) values ('a','b','c')

JSJoy 2010-07-22 13:58:26

ansaurus

tags:

views:

answers:

MS SQL Error "Invalid object name" on table I just created

Create the table:

I can select from the table:

But when I try to insert, I get an error that the object is not fonud:

Returns error:

related questions