DROP TABLE

DROP TABLE deletes the specified table and all its data from the database. For example:

    DROP TABLE tableName
INSERT INTO inserts data into the specified table. The first form inserts completely new data. Note that the insertion values must correspond in kind and number to the insertion columns. For example:

      INSERT INTO tableName [ (columnName [, columnName] ... ) ]
      VALUES (insertValue [, insertValue] ... )
The second form transfers a subset of data from existing tables or views:

      INSERT INTO tableName [(columnName [, columnName] ... )]
      querySpecification
[Contents] [Previous] [Next]
Click the icon to mail questions or corrections about this material to Taligent personnel.
Copyright©1995 Taligent,Inc. All rights reserved.

Generated with WebMaker