Dropping a Table

All data and structure in the table are deleted.

Any pending transactions are committed.

All indexes are dropped.

All constraints are dropped.

You cannot roll back the DROP TABLE statement.

DROP TABLE dept$80$;

Lab Exercise $3$:

Q$1$

Create the following tables.

Table name colleges

$\backslash$table$[[$Filed Name,Data type,Size,Note$],[$Coll$\_$no$,$Number,$4,$Primary key$],[$coll$\_$name,VARCHAR$2,20,],[$email$,$VARCHAR$2,20,],[$Phone$,$Number,$10,],[$Location$,,,]]$

Q$2$ add new column to the colleges table:

Column name address varchar$2(50).$

Q$3$ Change the size of coll$\_$name from $20$ to $30$

Q$4$ Remove the column name location

Q$5$Add new constraint to colleges table unique to email $.$

$10$

Prepared by Soad Mohammed

lab$4$