Managing tables

Managing tables

solidDB database tables are managed using SQL commands.

solidDB includes a sample script that creates and updates table, see SQL sample scripts.

The following table describes the statements used to perform common user management tasks.

Note If the autocommit mode is set to OFF, you must commit your work by using the following SQL statement:

COMMIT WORK;

If the autocommit mode is set to ON, the transactions are committed automatically.

Task	Example	Reference
Create a table	CREATE TABLE TEST (I INTEGER, TEXT VARCHAR);	CREATE TABLE
Delete a table	DROP TABLE TEST;	DROP TABLE
Add columns to a table	ALTER TABLE TEST ADD COLUMN C CHAR(1);	ALTER TABLE
Delete a column from a table	ALTER TABLE TEST DROP COLUMN C;	ALTER TABLE
List all user-created tables	LIST TABLES;	LIST
List all tables (including system tables)	SELECT * FROM TABLES;	SELECT
View basic table information	DESCRIBE TABLE TEST;	DESCRIBE

See

Go up to