Dropping Tables


Tables are dropped using the DROP TABLE command or through Enterprise Manager. The command to drop the sales table would be as follows :

 Drop table sales 

Multiple tables, separated by commas, can be referenced in a single DROP TABLE command. If a foreign key references a table, the referencing table or foreign key constraint must be dropped first. Any triggers and constraints associated with the table are also dropped when the table is dropped. To drop a table in Enterprise Manager, right-click the table in the Details pane and select Delete.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net