SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 736 Page Views: 

What does the DROP Table command do?



Posted By: Avi Date: 1 October 2010 12:18:08 PM
 Answer:

DROP command will delete the data as well as destroy the structure of the table. Once applied the table can't be retrieved back.


Posted By: avibtech


Date: 1 October 2010 12:18:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image rV87B3
Related Questions
SQL Server : Why are locks used in SQL server?

Why are locks used in SQL server?

In SQL Server locks help the users from making conflicting changes into the database. When the table....
Category: SQL Server Date: 10/1/2010 11:21:07 AM
SQL Server : Can a stored procedure have optional parameters?

Can a stored procedure have optional parameters?

Yes, a stored procedure can have optional parameters. With the help of default value for the optiona....
Category: SQL Server Date: 10/1/2010 11:20:07 AM
SQL Server : Can you tell the important features of sub-queries?

Can you tell the important features of sub-queries?

Subqueries are very beneficial if used properly.They allow to return the desired result in a single ....
Category: SQL Server Date: 10/1/2010 11:19:07 AM
SQL Server : What are DDL statements? Name some DDL Statements?

What are DDL statements? Name some DDL Statements?

DDL statements mean Data Definition Language statements. This the vocabulary used to define the data....
Category: SQL Server Date: 10/1/2010 11:18:07 AM
SQL Server : Does the order of columns matter while creating a table? i.e which coulms should come first and which last according to constraints and values?