[Home]  [Edit this page]  [Recent Changes]  [Special Pages]  [Help
SQLDropTable

(SQL) DROP TABLE

Removes a table from a database. It's syntax is:-

DROP TABLE tablename


Where tablename is the name of the table you want to remove. Some Databases allow the removal of more than one table per statement. You may do this by using a comma to separate table names with in list.

For example:

DROP TABLE a,b,c






last edited (October 23, 2006) by bilderbikkel, Number of views: 3020, Current Rev: 5 (Diff)

[Edit this page]  [Page history]  [What links here]  [Discuss this topic]  [Printer Friendly]  

Members

Username:

Password:


Register
Forgot Password?




Programmers Heaven - for .NET, Java, C/C++ and WEB Developers!
© 1996-2008 Community Networks Ltd. All rights reserved. Reproduction in whole or in part, in any form or medium without express written permission is prohibited. Violators of this policy may be subject to legal action. Please read Terms Of Use and Privacy Statement for more information. Development by Tore Nestenius at .NET Consultant - Synchron Data.