cb91AESx

1USE RewriteExam
2GO
3
4IF EXISTS(SELECT * FROM sys.objects
5          WHERE object_id = OBJECT_ID('dbo.Vendors')
6                AND type IN ('U')
7        )
8BEGIN
9    PRINT 'Vendors table already exists, dropping it now!'
10    DROP TABLE Vendors
11END
12GO
13
14PRINT 'Creating the "Vendors" Table'
15
16CREATE TABLE dbo.Vendors (
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  AccountNo          INT        PRIMARY KEY,
39  AccountDescription VARCHAR(45) NOT NULL,
40);
41GO