2.1.8 Deletions

Table of Contents Previous Next


2 SQL Tutorial : 2.1 Getting Started : 2.1.8 Deletions

2.1.8 Deletions
Rows can be removed from a table using the DELETE command. For example, the following sequence of commands shows the before and after results of deleting all employees in department 20.
Be extremely careful of giving a DELETE command without a WHERE clause such as the following:
DELETE FROM tablename;
Advanced Server supports SQL language that is compatible with Oracle syntax as well as syntax and commands for extended functionality (functionality that does not provide database compatibility for Oracle or support Oracle-styled applications).
Compatible SQL syntax and language elements
Supported SQL command syntax

2 SQL Tutorial : 2.1 Getting Started : 2.1.8 Deletions

Table of Contents Previous Next