CREATE语句创建表

CREATE TABLE Stores(StoreCode char (4)          NOT NULL PRIMARY KEY,Name      varchar (40)      NOT NULL,Address   varchar (40)      NOT NULL,City      varchar (20)      NOT NULL,State     char (2)          NOT NULL,Zip       char (5)          NOT NULL)

CREATE TABLE Sales(OrderNumber  varchar(20)    NOT NULL PRIMARY KEY,StoreCode    char(4)        NOT NULL,FOREIGN KEY(StoreCode) REFERENCES Stores(StoreCode),OrderDate    date           NOT NULL,Quantity     int            NOT NULL,Terms        varchar (12)   NOT NULL,TitleID      int            NOT NULL)

可查看Sales的属性：

EXEC sp_help Sales