lab7

CREATE TABLE customers
(  customerID VARCHAR(5) NOT NULL,
    companyName VARCHAR(40) NOT NULL,
    contactName VARCHAR(30) NOT NULL,
    address VARCHAR(60) ,
    cityChar VARCHAR(60),
    phoneChar VARCHAR(24) ,
    faxChar VARCHAR(24) ,

)
CREATE TABLE orders
(  orderId INT NOT NULL,
    customerChar VARCHAR(5) NOT NULL,
    orderDate DATE,
    shippedDate DATE,
    freihgt money,
    shipName VARCHAR(40) ,
    shipAddress VARCHAR(60) ,
    quantity INTEGER

)
---3---

ALTER TABLE orders
ADD shipRegion INTEGER

--4---
ALTER TABLE orders ALTER COLUMN shipRegion VARCHAR(8)

---5---
ALTER TABLE orders
DROP COLUMN shipRegion

---6----
ALTER TABLE customers
ADD PRIMARY KEY (customerID)


ALTER TABLE orders
DROP PRIMARY KEY
ADD PRIMARY KEY (customerID)


ALTER TABLE orders ADD FOREIGN KEY (customerID) REFERENCES orders(customerID)


--7------
ALTER TABLE orders
ADD DEFAULT getdate() FOR orderDate

---8--=-
ALTER TABLE orders
ADD CONSTRAINT  qut  CHECK(quantity BETWEEN 1 AND 30)
---9---
ALTER TABLE orders
DROP CONSTRAINT  qut
----10---

sp_rename 'customers.cityChar', 'town'