Effect on objects then you drop a table?

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,


SA4Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
cognos79Connect With a Mentor Commented:
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
 
cognos79Commented:
when you try to execute them, they will fail saying: object cannot be found
0
 
SA4Author Commented:
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
All Courses

From novice to tech pro — start learning today.