Everything about database,how to,example,guide,

7.6.1 is deleted with Enterprise Manager
The watch that should delete is clicked to choose from inside quick menu with right key in Enterprise Manager " delete (Delete) " option,Meet those who if place of graph 7-9 is shown,appear delete object dialog box,Click " Drop All " pushbutton,Can express in order to delete.Click " Show Dependencies " pushbutton,The dialog box that if place of graph 7-10 is shown,can appear namely.The object that it listed the watch relies on and the object that rely on a watch.When the object relies on a watch,Cannot delete a watch.

7.6.2 is deleted with command of DROP TABLE
Object of all reference that command of DROP TABLE can delete the data in a watch and watch to reach its and watch to concern, trigger, tie, license (the view related to the watch and memory process need use DROP VIEW and DROP PROCEDURE command to delete) .
Grammar of jussive of DROP TABLE is as follows:
DROP TABLE Table_name
If the watch that should delete is not in in current database,Answer what in the demonstrate in Table_name its belong to database and user name.Should delete the watch that expresses relevant couplet with this first before deleting a watch medium outside key word is restrained.After deleting a watch,Bind decided regulation or default to be worth can automatic untie a person.
Notice:Cannot delete a system to express.

Exemple 7-23:The watch Orders1 in deleting Mydb database.Drop Table Mydb.dbo.orders1

This chapter brief summary
This chapter introduced to found the relevant knowledge that expresses with administrative database,The detailed introduction that concerns the data in changing a table refers to chapter of 11 please " the database is updated " .