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

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

what information is maintained within the msdb database? : Sql server administration

0 Answers  

can you any body tell me which service pack is installed in the sql server?

3 Answers  

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

Differences between Standby Vs No recovery?

2 Answers   Wipro,




Explain acid?

0 Answers  

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

Explain indexed views and partitioned view with their syntax.

0 Answers  

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

What to check if a User database is locked?

0 Answers   TCS,

What are truncate options available in sql server? : sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories