Xg1@f[^\[X(Ϊq}X^CsΉ{§}X^Ccustomere[u)ΜXL[}
(a) Ϊq}X^
/****** SQL Server 6.5: Table dbo.Ϊq}X^ ******/
CREATE TABLE dbo.Ϊq}X^ (
cust_id int
NOT NULL ,
cust_lname char (20)
NULL ,
cust_fname char (20)
NULL ,
zip_code char (9) NULL
,
state char (10)
NULL ,
city char (20)
NULL ,
street char (40)
NULL ,
phone char (13)
NULL ,
start_date char (50)
NULL ,
end_date char (50) NULL
,
sex char (1)
NULL ,
CONSTRAINT PK_Ϊq}X^_1__10 PRIMARY KEY CLUSTERED
(
cust_id
)
)
GO
(b) sΉ{§}X^
/****** SQL Server 6.5: Table dbo.sΉ{§}X^ ******/
CREATE TABLE dbo.sΉ{§}X^ (
state_id varchar (6) NOT NULL ,
state_name char (24)
NULL ,
state_capital char (24)
NULL ,
country char (5) NULL ,
CONSTRAINT PK_sΉ{§}X^_1__10 PRIMARY KEY CLUSTERED
(
state_id
)
)
GO
(c) customere[u
/****** SQL Server 7.0: Table dbo.customer ******/
CREATE TABLE [dbo].[customer] (
[cust_id] [int]
NOT NULL ,
[name] [char] (50)
NULL ,
[zip_code] [char] (9)
NULL ,
[address1] [char] (500)
NULL ,
[address2] [char] (500)
NULL ,
[phone] [char] (13)
NULL ,
[start_date] [datetime]
NULL ,
[end_date] [datetime]
NULL ,
[sex] [char] (1)
NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[customer] WITH NOCHECK ADD
CONSTRAINT [PK_customer] PRIMARY KEY NONCLUSTERED
(
[cust_id]
) ON [PRIMARY]
GO