SQL•SQL References

SQL DROP COLUMN Keyword

Concept visual

SQL DROP COLUMN Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

DROP COLUMN Keyword

Drop Column

The DROP COLUMN

command is used to delete a column in an existing table. The following SQL deletes the "ContactName" column from the "Customers" table:

Example

ALTER TABLE Customers

DROP COLUMN ContactName;

SQL DROP COLUMN Keyword

Concept visual

SQL DROP COLUMN Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

DROP COLUMN Keyword

Drop Column

The DROP COLUMN

command is used to delete a column in an existing table. The following SQL deletes the "ContactName" column from the "Customers" table:

Example

ALTER TABLE Customers

DROP COLUMN ContactName;

SQL DROP COLUMN Keyword

SQL DROP COLUMN Keyword

DROP COLUMN Keyword

Previous

Next

Drop Column

The DROP COLUMN

Example

ALTER TABLE Customers

Previous

Next

SQL DROP COLUMN Keyword

SQL DROP COLUMN Keyword

DROP COLUMN Keyword

Previous

Next

Drop Column

The DROP COLUMN

Example

ALTER TABLE Customers

Previous

Next