Sometime we need to drop multiple database objects, and then we simply write Drop statement for each object.
But SQL Server provides a facility to drop multiple objects using single DROP statement.
Syntax:
DROP ObjectType ObjectName1, ObjectName2, ObjectName….
For Example :
Drop Table Employee, Address, Contact ;
1 comment:
Good article..I was looking for this.
Thanks
Pradeep
Post a Comment