Drop command is used to delete the Database or DataBaseObject (table,view,
function,indexes,procedures,triggers etc) from Sql Server permanently.
1.DROPPING A DATABASE
Syntax:
DROP DATABASE <DATABASE_NAME>
Example:
DROP DATABASE SRINIVASS
2.DROPPING A TABLE FROM DATABASE
Syntax:
DROP TABLE <TABLE_NAME>
example:
DROP TABLE EMPLOYEE
We can able to drop more than one table at a time also by separating comma
DROP TABLE EMPLOYEE1,EMPLOYEE2
we will see more examples in near future...
Thanks
GSV
function,indexes,procedures,triggers etc) from Sql Server permanently.
1.DROPPING A DATABASE
Syntax:
DROP DATABASE <DATABASE_NAME>
Example:
DROP DATABASE SRINIVASS
2.DROPPING A TABLE FROM DATABASE
Syntax:
DROP TABLE <TABLE_NAME>
example:
DROP TABLE EMPLOYEE
We can able to drop more than one table at a time also by separating comma
DROP TABLE EMPLOYEE1,EMPLOYEE2
we will see more examples in near future...
Thanks
GSV
No comments:
Post a Comment