Solved

Effect on objects then you drop a table?

Posted on 2007-04-03
3
159 Views
Last Modified: 2010-03-19
Hi Experts,
If I drop a table what would happened to the objects (Views, Triggers, Sproc, UDFs) that depends on that table?
I'm working on sql server 2005.

Thx,


0
Comment
Question by:SA4
  • 2
3 Comments
 
LVL 3

Expert Comment

by:cognos79
ID: 18844613
when you try to execute them, they will fail saying: object cannot be found
0
 

Author Comment

by:SA4
ID: 18844629
But will they be droped too. let say if I modify a sproc so it uses another table will it work?
And what about views and UDFs?
0
 
LVL 3

Accepted Solution

by:
cognos79 earned 50 total points
ID: 18844681
they wont get dropped. you might get a warning saying the sprocs, views that depend on tht table will be affected.

if you modify sproc to use another table there shldnt be no problem.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now