SQL语句建表怎么建啊,自己写了第一个,为什么老显示字段定义语法错误????

2025-03-06 13:38:02
推荐回答(1个)
回答1:

1.
CREATE TABLE [dbo].[产品信息](
[产品编号] [char](5) COLLATE Chinese_PRC_CI_AS NOT NULL,
[产品名称] [char](30) COLLATE Chinese_PRC_CI_AS NOT NULL,
[价格] [float] NULL CONSTRAINT [DF_产品信息_价格] DEFAULT ((10.00)),
[库存量] [int] NULL CONSTRAINT [DF_产品信息_库存量] DEFAULT ((0)),
[地址] [char](20) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_产品信息] PRIMARY KEY CLUSTERED
(
[产品编号] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
2.
CREATE TABLE [dbo].[销售信息](
[产品编号] [char](6) COLLATE Chinese_PRC_CI_AS NOT NULL,
[产品名称] [char](30) COLLATE Chinese_PRC_CI_AS NOT NULL,
[客户名称] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[单价] [float] NULL CONSTRAINT [DF_销售信息_单价] DEFAULT ((10.00)),
[数量] [int] NULL CONSTRAINT [DF_销售信息_数量] DEFAULT ((0)),
[金额] [float] NULL CONSTRAINT [DF_销售信息_金额] DEFAULT ((0)),
CONSTRAINT [PK_销售信息] PRIMARY KEY CLUSTERED
(
[产品编号] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
3.
CREATE TABLE [dbo].[生产信息](
[部门编号] [char](6) COLLATE Chinese_PRC_CI_AS NOT NULL,
[负责人] [char](8) COLLATE Chinese_PRC_CI_AS NOT NULL,
[联系电话] [char](20) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_生产信息] PRIMARY KEY CLUSTERED
(
[部门编号] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO