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
Solved

Effect on objects then you drop a table?

Posted on 2007-04-03
3
163 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

856 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