/****** 对象: Table [dbo].[tab_1] 脚本日期: 08/22/2007 09:50:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tab_1]( [产品编号] [int] NOT NULL, [产品名称] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [产品价格] [float] NULL, PRIMARY KEY CLUSTERED ( [产品编号] 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 /****** 对象: Table [dbo].[tab_2] 脚本日期: 08/22/2007 09:50:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tab_2]( [产品编号] [int] NOT NULL, [供应商] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, PRIMARY KEY CLUSTERED ( [产品编号] 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].[tab_2] WITH CHECK ADD CONSTRAINT [FK_tab_2_tab_1] FOREIGN KEY([产品编号]) REFERENCES [dbo].[tab_1] ([产品编号]) GO ALTER TABLE [dbo].[tab_2] CHECK CONSTRAINT [FK_tab_2_tab_1]
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tab_1]( [产品编号] [int] NOT NULL, [产品名称] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [产品价格] [float] NULL, PRIMARY KEY CLUSTERED ( [产品编号] ASC )) ON [PRIMARY]GO SET ANSI_PADDING OFF /****** 对象: Table [dbo].[tab_2] 脚本日期: 08/22/2007 09:50:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tab_2]( [产品编号] [int] NOT NULL, [供应商] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, PRIMARY KEY CLUSTERED ( [产品编号] ASC )) ON [PRIMARY]GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[tab_2] WITH CHECK ADD CONSTRAINT [FK_tab_2_tab_1] FOREIGN KEY([产品编号]) REFERENCES [dbo].[tab_1] ([产品编号]) GO ALTER TABLE [dbo].[tab_2] CHECK CONSTRAINT [FK_tab_2_tab_1]
产品名称 varchar(20) not null
产品价格 money not null)
CREATE TABLE tab_2(产品编号 integer(10) references tab_1(产品编号), 供应商 varchar(), primary key(产品编号))我就会这些,还不知道对不对,表2中的“产品编号”是主键又要求关联表1,不知道是不是这么写
后边的IP:10.174.179.174 数据库:test 用户名:SA 密码:SA
如何写?请指教
产品名称 varchar(20) not null,
产品价格 money not null,
primary key(产品编号))
CREATE TABLE [dbo].[表二](
[产品编号] [int] NOT NULL,
[供应商] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_表二] PRIMARY KEY CLUSTERED
(
[产品编号] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
如何写?请指教
--------------------------------
打开查询分析器,登录服务器,选中数据库,运行代码就行了。
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tab_1](
[产品编号] [int] NOT NULL,
[产品名称] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[产品价格] [float] NULL,
PRIMARY KEY CLUSTERED
(
[产品编号] 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
/****** 对象: Table [dbo].[tab_2] 脚本日期: 08/22/2007 09:50:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tab_2](
[产品编号] [int] NOT NULL,
[供应商] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
[产品编号] 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].[tab_2] WITH CHECK ADD CONSTRAINT [FK_tab_2_tab_1] FOREIGN KEY([产品编号])
REFERENCES [dbo].[tab_1] ([产品编号])
GO
ALTER TABLE [dbo].[tab_2] CHECK CONSTRAINT [FK_tab_2_tab_1]
这些?用查询分析器连过去,或者用OSQL ISQL等工具
用楼上各位的代码创建就可以了啊?
服务器: 消息 170,级别 15,状态 1,行 8
第 8 行: '(' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 7
第 7 行: '(' 附近有语法错误。
服务器: 消息 4902,级别 16,状态 1,行 1
无法更改表 'dbo.tab_2',因为数据库 'master' 中不存在此表。
服务器: 消息 4902,级别 16,状态 1,行 1
无法更改表 'dbo.tab_2',因为数据库 'master' 中不存在此表。运行出现这样的错误是怎么回事
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tab_1](
[产品编号] [int] NOT NULL,
[产品名称] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[产品价格] [float] NULL,
PRIMARY KEY CLUSTERED
(
[产品编号] ASC
)) ON [PRIMARY]GO
SET ANSI_PADDING OFF
/****** 对象: Table [dbo].[tab_2] 脚本日期: 08/22/2007 09:50:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tab_2](
[产品编号] [int] NOT NULL,
[供应商] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
[产品编号] ASC
)) ON [PRIMARY]GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[tab_2] WITH CHECK ADD CONSTRAINT [FK_tab_2_tab_1] FOREIGN KEY([产品编号])
REFERENCES [dbo].[tab_1] ([产品编号])
GO
ALTER TABLE [dbo].[tab_2] CHECK CONSTRAINT [FK_tab_2_tab_1]