技术类-优快云博客

本文介绍如何使用SQL语句创建两个数据库表：Company和Customer。Company表包含公司基本信息如公司名称、地址等；Customer表则记录了客户详情，包括客户ID、所属公司ID、产品信息及价格等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://www.yuanma.org/data/2007/1214/article_2924.htm
http://www.vdisk.cn/user/admin/ghbullor
USE [cm]
GO
/****** 对象: Table [dbo].[Company] 脚本日期: 06/12/2010 23:59:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Company](
[CompanyId] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CompanyName] [nvarchar](80) COLLATE Chinese_PRC_CI_AS NULL,
[Address] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[Tel] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Management] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[City] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Fax] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Character] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
USE [cm]
GO
/****** 对象: Table [dbo].[Customer] 脚本日期: 06/13/2010 00:00:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customer](
[CustomerId] [varchar](30) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CompanyId] [varchar](30) COLLATE Chinese_PRC_CI_AS NOT NULL,
[ProductId] [varchar](30) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CustomerName] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[Tel] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Address] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[EMail] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ProductName] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[ProductSpec] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[ProductAmount] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ModelType] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Price] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Currency] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Supply] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[Position] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF