Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Effect on objects then you drop a table?

Posted on 2007-04-03
3
Medium Priority
?
167 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 150 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

730 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