[prev] [index] [next]

SQL: Changing the Database (cont)

SQL provides mechanisms for modifying table meta-data:
  • CREATE TABLE ... create a new empty table
  • DROP TABLE ... remove table from database (incl. tuples)
  • ALTER TABLE ... change properties of existing table
Analogous operations on other kinds of database objects:
  • CREATE VIEW,   CREATE FUNCTION,   CREATE TRIGGER, ...
  • DROP VIEW,   DROP FUNCTION,   DROP TRIGGER, ...
  • ALTER VIEW,   etc. available, but are non-standard