ALTER Lab 20.11

CREATE TABLE customers
(customerid CHAR(5) NOT NULL PRIMARY KEY,
companyname VARCHAR(40) NOT NULL,
contactname CHAR(40),
address VARCHAR(60),
city CHAR(15),
phone CHAR(24),
fax CHAR(24)
)

CREATE TABLE ORDERS
(orderid INT NOT NULL PRIMARY KEY,
customerid CHAR(5) NOT NULL FOREIGN KEY REFERENCES customers(customerid),
orderdate DATE,
shippeddate DATE,
freight money,
shipname VARCHAR(40),
shipaddress VARCHAR(60),
quantity INTEGER
)

ALTER TABLE orders
ADD shipregion INTEGER

ALTER TABLE orders
DROP COLUMN shipregion

DROP TABLE customers
DROP TABLE orders

-------------------Task 7-------------------------------
ALTER TABLE orders
ADD CONSTRAINT orderd DEFAULT SYSDATETIME() FOR orderdate

-------------------TASK 8------------------------------
ALTER TABLE orders
ADD CONSTRAINT o_con CHECK(quantity <=30 AND quantity >= 1)

--------------------TASK 9----------------------------
ALTER TABLE orders
DROP o_con

---------------------TASK 10-------------------------
sp_rename 'customers.city', 'town'