Drop - DotNet and DataBase

Saturday, 11 August 2018

Drop


Drop command is used to drop a database and its objects.
Drop command removes the objects permanently from the database server. So, we should be careful while using the drop command.

Drop a database
Syntax:
DROP DATABASE <tbl_Name>
Example:

DROP DATABASE Employee 


Here Employee is my Database name

Drop a table
Syntax:
DROP TABLE <tbl_Name>
Example:

DROP TABLE EmployeeInfo

No comments:

Post a Comment

x

Get Updates On

Discussion updates

Straight Into Your INBOX!

Enter your email address to subscribe to this website and receive notifications of new posts by email.