Eine Einführung in
SQL
DROP an unwanted table
SQLite
Naturally, all of the data in the table is lost when the table is dropped.
Execute set up
code
CREATE TABLE t_test (a INTEGER NOT NULL PRIMARY KEY ,b VARCHAR(10) )
DROP TABLE t_test
Specific to SQLite
none
DB2
Naturally, all of the data in the table is lost when the table is dropped.
Execute set up
code
CREATE TABLE t_test (a INTEGER NOT NULL PRIMARY KEY ,b VARCHAR(10) )
DROP TABLE t_test
Specific to DB2
none
MS Access
Naturally, all of the data in the table is lost when the table is dropped.
Execute set up
code
CREATE TABLE t_test (a INTEGER NOT NULL PRIMARY KEY ,b VARCHAR(10) )
DROP TABLE t_test
Specific to MS Access
none
PostgreSQL
Naturally, all of the data in the table is lost when the table is dropped.
Execute set up
code
CREATE TABLE t_test (a INTEGER NOT NULL PRIMARY KEY ,b VARCHAR(10) )
DROP TABLE t_test
Specific to PostgreSQL
none
Oracle
Naturally, all of the data in the table is lost when the table is dropped.
Execute set up
code
CREATE TABLE t_test (a INTEGER NOT NULL PRIMARY KEY ,b VARCHAR(10) )
DROP TABLE t_test
Specific to Oracle
none
MS SQL Server
Naturally, all of the data in the table is lost when the table is dropped.
Execute set up
code
CREATE TABLE t_test (a INTEGER NOT NULL PRIMARY KEY ,b VARCHAR(10) )
DROP TABLE t_test
Specific to MS SQL Server
none
MySQL
Naturally, all of the data in the table is lost when the table is dropped.
Execute set up
code
CREATE TABLE t_test (a INTEGER NOT NULL PRIMARY KEY ,b VARCHAR(10) )
DROP TABLE t_test
Specific to MySQL
none
Sybase
Naturally, all of the data in the table is lost when the table is dropped.
Execute set up
code
CREATE TABLE t_test (a INTEGER NOT NULL PRIMARY KEY ,b VARCHAR(10) )
DROP TABLE t_test
Specific to Sybase
none
Mimer SQL
Naturally, all of the data in the table is lost when the table is dropped.
Execute set up
code
CREATE TABLE t_test (a INTEGER NOT NULL PRIMARY KEY ,b VARCHAR(10) )
DROP TABLE t_test
Specific to Mimer SQL
none