1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

Question Posted / maheswari


If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, ..

Answer / anusha

No, dropping the table does not delete the corresponding table objects. Need to drop Indexes, views first before dropping the table.

eg:
drop view <database name>.<view name>
alter table <database name>.<table name> drop <index type>
drop table <database name>.<table name>

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

select empid empname from employee What is the result for the about query?

4 Answers  

How to create a scrollable cursor with the scroll option?

0 Answers  

How do I start sql server 2017?

0 Answers  

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,




is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

How to move database physical files in ms sql server?

0 Answers  

What's new in sql management studio for sql server? : sql server management studio

0 Answers  

How to Update from select query in sql server?

0 Answers  

What are views used for?

0 Answers  

Explain Different types of Projects?

1 Answers  

What is the use of for clause?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories