SQL - DDL

This post contains a collection of SQL DDL (Data Definition Language) statements.

DDL or Data Definition Language consists of SQL statements which create, drop, or alter a table.

Adding a column in a table:

alter table books add column author varchar(100);

Dropping a column from a table:

alter table books drop column author;

b