j7jgpTUH

1USE RewriteExam
2GO
3
4IF EXISTS(SELECT * FROM sys.objects
5          WHERE object_id = OBJECT_ID('dbo.Vendors')
6            AND type IN ('U'))
7BEGIN
8    PRINT 'Vendors table already exists, dropping it now!'
9    DROP TABLE Vendors
10END
11GO
12
13PRINT 'Creating the "Vendors" Table'
14
15CREATE TABLE dbo.Vendors 
16(
17    VendorID INT PRIMARY KEY, 
18    VendorName VARCHAR(45) NOT NULL,
19    VendorAddress VARCHAR(45) NULL,
20    VendorCity VARCHAR(45) NOT NULL,
21    VendorState VARCHAR(45) NOT NULL,
22    VendorZipCode VARCHAR(45) NOT NULL,
23    VendorPhone VARCHAR(45) NULL,
24    VendorContactLName VARCHAR(7) NULL,
25    VendorContactFName VARCHAR(14) NULL,
26    AcountNo INT NOT NULL,
27    ModifiedDate SMALLDATETIME NOT NULL,
28    AccountNo INT FOREIGN KEY,
29    CONSTRAINT PK_Vendors_VendorID 
30         PRIMARY KEY (VendorID)
31    --REFERENCES Vendors (VendorID)
32);
33GO
34
35PRINT 'Creating the "GLAccounts" Table'
36
37CREATE TABLE dbo.GLAccounts 
38(
39    AccountNo INT PRIMARY KEY,
40    AccountDescription VARCHAR(45) NOT NULL,
41);
42GO