Buy Questpond's video subscriptions on
huge discount
.
Online: 920
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
Can you drop a Parent Table with out affecting its child tables?
Posted by
Sriramnandha
on 6/3/2012 | Category:
Sql Server Interview questions
| Views: 2900 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
No. First you need to drop all the Foreign Key relationships and then only you can drop Parent Table.
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
How to Alter constraint in sql server?
Next > :
How to disable and Enable the constraints?
Comments or Responses
Login to post response
More Interview Questions by Sriramnandha
How to disable and Enable the constraints?
Difference between Primary key,unique key,Alternate Key?
What is the table name,that contains the Primary Key, Unique Key and F ...
Difference between Check Constraint and Rule?
what is Check Constraint in SQL Server ?
Difference between Primary key and unique key in SQL Server?
What is Unique Key in SQL Server?
what is Primary Key in SQL Server
Latest Interview Questions
Can we define two main methods in an application ?
Does the view continue to exist if the table is dropped from the datab ...
Can you update the data in a view?
Advantages for using a View in SQL Server ?
If you have specified NOT NULL Constraint, will that column allow ' ...
Can we define multiple Unique Keys in a table ?
In WCF, can data contract classes inherit from one another?
Are the two statements same :- select custid from tbl_order; sel ...
More ...