You are here

ALTER TABLE - modify tables

Error message

Notice: unserialize(): Error at offset 1842 of 1865 bytes in variable_initialize() (line 1202 of /is/htdocs/wp1033310_AQAMEFYCW9/www/includes/bootstrap.inc).

Syntax

Description

    With ALTER TABLE you can add, remove or modify table columns. depending on the database management system, the table should not be empty.

    Example:

ALTER TABLE tkunden ADD COLUMN new_number INTEGER NOT NULL;

Adds the new INTEGER column new_number to existing table tkunden and sets a NOT NULL contraint.

Example:

ALTER TABLE TABLE tkunden DROP COLUMN new_number;

Drops the column new_number from the table tkunden.

Categories: 
Error | AAM

Error

The website encountered an unexpected error. Please try again later.