"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/alter_table.rst" (6 May 2012, 497 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

ALTER TABLE

An ALTER statement modifies the definition (structure) of a table inside Drizzle. The types of objects that can be altered depends on which RDBMS is being used.

The ALTER TABLE statement is used to change a table definition by:

  1. Adding, dropping, modifying table columns
  2. Adding and dropping constraints
  3. Enabling and Disabling constraints
  4. Rename a table

add something about current implementation: i.e. write blocking copying alter table.