June 2004
Intermediate to advanced
848 pages
21h 28m
English
The DELETE statement is used to remove records from a table, and the DROP statement is used to completely remove all trace of a table from the database.
The DELETE statement has this general format:
|
Format of SQL DELETE statement |
Additional information |
|
|
If you forget the “where” clause, all records in the table are deleted! A table with no records still exists in the database, and can be queried, updated, etc. To get rid of all traces of a table (not ...
Read now
Unlock full access