PROBLEM while running a query

Question

2.50/5 (2 votes)

See more:

while running a query like

SQL

select * from table_name

it throws error

SQL

Invalid object name 'table_name'.

but when running the query like

SQL

select * from rlc.table_name

rlc is my db name its running correctly

plz someone suggess how to solve the problem

Posted 29-Dec-12 5:12am

Miss Maheshwari

Add a Solution

4 solutions

Solution 4

there are 2 possibilities for your problem

1. your database name may not be rcl on target , by default it may be master db or some other db
2. your table name may be in rcl schema. if your table is in other than dbo schema then you have to specify schema name. then only your query will be execute

Posted 30-Dec-12 20:09pm

FranklinRemo

Solution 1

Check your connection string - you probably haven't set the "Initial Catalog" value.

Posted 29-Dec-12 5:18am

OriginalGriff

Comments

Miss Maheshwari 29-Dec-12 11:25am

i am running the query from sql server query analyzer

Solution 2

esto se debe a que nos has escogido la base de datos donde lo muestro a continuación

master
rcl

Rough translation(?):

This is because you have not chosen the database correctly. Change as below

master
rcl

Posted 29-Dec-12 5:22am

farey2000

Updated 29-Dec-12 5:41am

v2

Comments

Wendelius 29-Dec-12 11:42am

Because of site policy, only English posts are accepted.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2012-12-29T05:38:00

Solution 3

Looks like the table is created in a schema called rlc. If this is true, you have to define the schema name for the table (as you did in second example) or create a synonym for it.

Consider the following:

SQL

create schema testschema;

create table testschema.sometable (
   col1 int
);

select * from sometable; // FAILS

select * from testschema.sometable; //OK

create synonym sometable for testschema.sometable;

select * from sometable; //OK

select * from testschema.sometable; //OK

Posted 29-Dec-12 5:38am

Wendelius

Comments

Miss Maheshwari 29-Dec-12 11:50am

Thank you very much....yes...:)
i was in trouble from last week...thank you once again

Wendelius 29-Dec-12 11:54am

You're welcome :)

ridoy 29-Dec-12 12:42pm

+5

Wendelius 29-Dec-12 15:00pm

Thanks :D

Sergey Alexandrovich Kryukov 29-Dec-12 21:59pm

To the point, nice and simple explanation, a 5.
—SA

Wendelius 4-Jan-13 15:06pm

Thank you :)