update part 2

Group Project Part 2 - Checklist explanations

Part 2 - Lab Project Checklist:

 Please do not include part 1.

1. SQL commands to ALTER a table, add a column, lengthen a column, shorten a column, change a data type for a column from NUMBER to CHAR and then CHAR to NUMBER.

Alter Table Cust Add cust_last_Name char(50);

2. Commands to create another table like an existing one but without one column. Then load the data from the old to the new table. Then reestablish referential integrity. Then drop the old table and rename the new one.

Create table new_table

As(Select * From cust);

17.  Scripts used to create synonyms.

Create Synonym Offices For Cust;