SA4
asked on
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,
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,
when you try to execute them, they will fail saying: object cannot be found
ASKER
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?
And what about views and UDFs?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.