My SQL database project is not showing error.

Question

1.00/5 (1 vote)

See more:

Hi,
I have a SQL database project in visual studio 2015.On compiling the project not showing the error for the missing table object.
A stored procedure using a table which is deleted form project and after the compilation it is not showing the error.

Does it is possible to find out the missing object reference on the compile time in sql database project ?

What I have tried:

1. Create a database project.
2. Delete the table from project which is already used by a stored procedure.
3. Compile the project.

Posted 2-Jun-20 0:03am

Siddharth Rai

Updated 2-Jun-20 0:08am

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2020-06-02T00:10:00

Solution 1

If the table is in your database then you can;t check for it at compile time, only at run time.
The compiler does not open or attempt to open any connection to your database - it not only doesn't know the connection string, it has no idea to to communicate with your DB at all!

So no: you can't check a table exists at compile time. Even if you could - which you can't - it would be of no use, as the table could be deleted thirty seconds later and the EXE file would still be the same.

Posted 2-Jun-20 0:10am

OriginalGriff

Comments

Siddharth Rai 2-Jun-20 8:31am

Thank you such much for help,
Sir, but i am asking about my database project solution.
Example: i have table Product.sql in Table directory and Stored procedure PROC_PRODUCT.SQL in Stored Procedure Directory.
both are in same solution . and PRC_PRODUCT.sql is using Product table.

once i am deleting the table Product.sql from table directory and build the project. it is not showing error .