SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[authors]( [au_id] [dbo].[id] NOT NULL, [au_lname] [varchar](40) NOT NULL, [au_fname] [varchar](20) NOT NULL, [phone] [char](12) NOT NULL DEFAULT ('UNKNOWN'), [address] [varchar](40) NULL, [city] [varchar](20) NULL, [state] [char](2) NULL, [zip] [char](5) NULL, [contract] [bit] NOT NULL, CONSTRAINT [UPKCL_auidind] PRIMARY KEY CLUSTERED ( [au_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[authors] WITH CHECK ADD CHECK (([au_id] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]')) GO ALTER TABLE [dbo].[authors] WITH CHECK ADD CHECK (([zip] like '[0-9][0-9][0-9][0-9][0-9]')) 行否?
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__titleauth__au_id__0519C6AF]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[titleauthor] DROP CONSTRAINT FK__titleauth__au_id__0519C6AF GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[authors] GOCREATE TABLE [dbo].[authors] ( [au_id] [id] NOT NULL , [au_lname] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL , [au_fname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [phone] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [address] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [city] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [state] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [zip] [char] (5) COLLATE Chinese_PRC_CI_AS NULL , [contract] [bit] NOT NULL ) ON [PRIMARY] GO
USE [pubs] GO/****** Object: Table [dbo].[authors] Script Date: 02/23/2010 15:16:36 ******/ SET ANSI_NULLS ON GOSET QUOTED_IDENTIFIER ON GOSET ANSI_PADDING ON GOCREATE TABLE [dbo].[authors]( [au_id] [dbo].[id] NOT NULL, [au_lname] [varchar](40) NOT NULL, [au_fname] [varchar](20) NOT NULL, [phone] [char](12) NOT NULL, [address] [varchar](40) NULL, [city] [varchar](20) NULL, [state] [char](2) NULL, [zip] [char](5) NULL, [contract] [bit] NOT NULL, CONSTRAINT [UPKCL_auidind] PRIMARY KEY CLUSTERED ( [au_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]GOSET ANSI_PADDING OFF GOALTER TABLE [dbo].[authors] WITH CHECK ADD CHECK (([au_id] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]')) GOALTER TABLE [dbo].[authors] WITH CHECK ADD CHECK (([zip] like '[0-9][0-9][0-9][0-9][0-9]')) GOALTER TABLE [dbo].[authors] ADD DEFAULT ('UNKNOWN') FOR [phone] GO
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[authors](
[au_id] [dbo].[id] NOT NULL,
[au_lname] [varchar](40) NOT NULL,
[au_fname] [varchar](20) NOT NULL,
[phone] [char](12) NOT NULL DEFAULT ('UNKNOWN'),
[address] [varchar](40) NULL,
[city] [varchar](20) NULL,
[state] [char](2) NULL,
[zip] [char](5) NULL,
[contract] [bit] NOT NULL,
CONSTRAINT [UPKCL_auidind] PRIMARY KEY CLUSTERED
(
[au_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[authors] WITH CHECK ADD CHECK (([au_id] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'))
GO
ALTER TABLE [dbo].[authors] WITH CHECK ADD CHECK (([zip] like '[0-9][0-9][0-9][0-9][0-9]'))
行否?
ALTER TABLE [dbo].[titleauthor] DROP CONSTRAINT FK__titleauth__au_id__0519C6AF
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[authors]
GOCREATE TABLE [dbo].[authors] (
[au_id] [id] NOT NULL ,
[au_lname] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[au_fname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[phone] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[address] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[city] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[state] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[zip] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[contract] [bit] NOT NULL
) ON [PRIMARY]
GO
GO/****** Object: Table [dbo].[authors] Script Date: 02/23/2010 15:16:36 ******/
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GOSET ANSI_PADDING ON
GOCREATE TABLE [dbo].[authors](
[au_id] [dbo].[id] NOT NULL,
[au_lname] [varchar](40) NOT NULL,
[au_fname] [varchar](20) NOT NULL,
[phone] [char](12) NOT NULL,
[address] [varchar](40) NULL,
[city] [varchar](20) NULL,
[state] [char](2) NULL,
[zip] [char](5) NULL,
[contract] [bit] NOT NULL,
CONSTRAINT [UPKCL_auidind] PRIMARY KEY CLUSTERED
(
[au_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]GOSET ANSI_PADDING OFF
GOALTER TABLE [dbo].[authors] WITH CHECK ADD CHECK (([au_id] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'))
GOALTER TABLE [dbo].[authors] WITH CHECK ADD CHECK (([zip] like '[0-9][0-9][0-9][0-9][0-9]'))
GOALTER TABLE [dbo].[authors] ADD DEFAULT ('UNKNOWN') FOR [phone]
GO
CREATE TABLE [dbo].[authors] (
[au_id] [id] NOT NULL ,
[au_lname] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[au_fname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[phone] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[address] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[city] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[state] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[zip] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[contract] [bit] NOT NULL
) ON [PRIMARY]
GO
[/Quote]