Alter

a description of sql alter Statement

---

ALTER TABLE ADD

---

syntax

ALTER TABLE TableName
ADD NewCollumName DataType;

---

Example

ALTER TABLE customer
ADD Email varchar(255);

adds a collum Email to table customer

---

ALTER TABLE DROP COLLOM

---

syntax

ALTER TABLE tableName
DROP COLUMN CollumnName;

removes a collumn from a table

---

Example

ALTER TABLE customers 
DROP COLUMN email;

removes column from table

---

ALTER RENAME COLUMN

---

syntax

ALTER TABLE TableName
RENAME COLUMN OldName TO NewName

---

ALTER COLUMN Datatype

---

syntax

ALTER TABLE TableName
ALTER COLUMN ColumnName DataType;

the datatype speseficy what we would like to be stored in a collums fields for available Datatype check datatype page