Altering and Dropping Tables : Alter Table : Table Index SQL / MySQL

Ajax
Ajax Examples Ajax Tutorials Scripts and Programs
Javascript
Javascript Examples Tutorials DHTML Tutorials Javascript References Scripts and Programs
HTML
HTML Tutorials HTML References HTML DOM 0 References HTML DOM 2 References
CSS
CSS Tutorials CSS References
PHP
PHP Source Code PHP References Scripts and Programs
C#
C# Source Code C# Examples

SQL / MySQL » Table Index » Alter Table »

Altering and Dropping Tables




Drop table Stock;

CREATE TABLE Stock
(
   ID SMALLINT
);

Describe Stock;

ALTER TABLE Stock
ADD COLUMN Quantity SMALLINT UNSIGNED NOT NULL,
MODIFY ID SMALLINT UNSIGNED NOT NULL,
ADD PRIMARY KEY (ID);

Describe Stock;

ALTER TABLE Stock
DROP COLUMN Quantity,
DROP PRIMARY KEY;

Describe Stock;