Week2 - Data Definition Language / Design

The questions can come in any order, so make sure you are selecting right option for all questions.

1. Write a query to create 'building' table.

create table building(
id integer not null,
owner_name varchar(100) not null,
address varchar(100) not null,
building_type_id integer not null,
contact_number varchar(100) not null,
email_address varchar(100)
)

2. Write a query to change the column name 'email_address' to 'email' in the building table.

alter table building rename column email_address to email;

3. Write a query to add new column "description" of type varchar(255) add not null constraint to building table.

alter table building add description varchar(255) NOT NULL;

4. Write a query to remove the column 'address' from the 'building' table.

alter table building drop column address;

5. Write a query to change the type of field 'owner_name' in the 'building' table to varchar(500).

alter table building modify owner_name varchar(500);

6. Write a query to drop table 'building'.

drop table building;