Mbbt. Sql tili

...

;

Mavjud jadval ustunini o’zgartirish

ALTER TABLE table_name

MODIFY column_name column_definition

[ FIRST | AFTER column_name ];

ALTER TABLE table_name

MODIFY column_name column_definition

[ FIRST | AFTER column_name ],

MODIFY column_name column_definition

[ FIRST | AFTER column_name ],

...

;

Jadval ustunini o’chirish

ALTER TABLE table_name

DROP COLUMN column_name;

Jadval ustunining nomini o’zgartirish

ALTER TABLE table_name

CHANGE COLUMN old_name new_name column_definition

[ FIRST | AFTER column_name ]

Mavjud jadval nomini o’zgartirish

ALTER TABLE table_name

RENAME TO new_table_name;

Jadvalni o’chirish

DROP TABLE [ IF EXISTS ]

table_name1, table_name2, ...

[ RESTRICT | CASCADE ];

Jadvallarni bog’lash

FOREIGN KEY

[CONSTRAINT [symbol]] FOREIGN KEY