Posts Tagged ‘create’

ALTER TABLE

Понедельник, Март 24th, 2008 Нет комментариев

Under : , , , , , , , , , , ,

СИНТАКСИС:
ALTER [IGNORE] TABLE table_name alter_specification [, alter_specification ...]

alter_specification:
ADD [COLUMN] create_definition or
CHANGE [COLUMN] old_column_name create_definition or
ALTER [COLUMN] column_name { SET default | DROP DEFAULT } or
DROP [COLUMN] column_name or DROP PRIMARY KEY or DROP INDEX key_name
DROP FOREIGN KEY key_name
(далее…)