SQL2012转MYsql

1asas 1asas 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
USE [a0113113041]
GO
/****** Object: Table [dbo].[Category] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Category](
[CategoryID] [int] IDENTITY(1,1) NOT NULL,
[Category] [nvarchar](50) NULL,
CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED
(
[CategoryID] 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
/****** Object: Table [dbo].[Color] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Color](
[ColorID] [int] IDENTITY(1,1) NOT NULL,
[Color] [nvarchar](50) NULL,
[CVID] [int] NULL,
CONSTRAINT [PK_Color] PRIMARY KEY CLUSTERED
(
[ColorID] 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
/****** Object: Table [dbo].[KC] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KC](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CategoryID] [int] NULL,
[VarietiesID] [int] NULL,
[Type] [nvarchar](50) NULL,
[ColorID] [int] NULL,
[LayerID] [int] NULL,
[ThicknessID] [int] NULL,
[Specification] [nvarchar](50) NULL,
[Meter] [nvarchar](50) NULL,
[Square] [nvarchar](50) NULL,
[Data] [nvarchar](50) NULL,
[Number] [int] NULL,
[Remark] [nvarchar](50) NULL,
[Nmb] [nchar](10) NULL,
CONSTRAINT [PK_KC] PRIMARY KEY CLUSTERED
(
[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
/****** Object: Table [dbo].[Layer] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Layer](
[LayerID] [int] IDENTITY(1,1) NOT NULL,
[Layer] [nvarchar](50) NULL,
[LCID] [int] NULL,
CONSTRAINT [PK_Layer] PRIMARY KEY CLUSTERED
(
[LayerID] 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
/****** Object: Table [dbo].[Thickness] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Thickness](
[ThicknessID] [int] IDENTITY(1,1) NOT NULL,
[Thickness] [nchar](10) NULL,
[TLID] [int] NULL,
CONSTRAINT [PK_Thickness] PRIMARY KEY CLUSTERED
(
[ThicknessID] 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
/****** Object: Table [dbo].[Varieties] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Varieties](
[VarietiesID] [int] IDENTITY(1,1) NOT NULL,
[Varieties] [nvarchar](50) NULL,
[VCID] [int] NULL,
CONSTRAINT [PK_Varieties] PRIMARY KEY CLUSTERED
(
[VarietiesID] 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
ALTER TABLE [dbo].[Color] WITH CHECK ADD CONSTRAINT [FK_Color_Varieties] FOREIGN KEY([CVID])
REFERENCES [dbo].[Varieties] ([VarietiesID])
GO
ALTER TABLE [dbo].[Color] CHECK CONSTRAINT [FK_Color_Varieties]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Category] FOREIGN KEY([CategoryID])
REFERENCES [dbo].[Category] ([CategoryID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Category]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Color] FOREIGN KEY([ColorID])
REFERENCES [dbo].[Color] ([ColorID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Color]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Layer] FOREIGN KEY([LayerID])
REFERENCES [dbo].[Layer] ([LayerID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Layer]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Thickness] FOREIGN KEY([ThicknessID])
REFERENCES [dbo].[Thickness] ([ThicknessID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Thickness]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Varieties] FOREIGN KEY([VarietiesID])
REFERENCES [dbo].[Varieties] ([VarietiesID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Varieties]
GO
ALTER TABLE [dbo].[Layer] WITH CHECK ADD CONSTRAINT [FK_Layer_Color] FOREIGN KEY([LCID])
REFERENCES [dbo].[Color] ([ColorID])
GO
ALTER TABLE [dbo].[Layer] CHECK CONSTRAINT [FK_Layer_Color]
GO
ALTER TABLE [dbo].[Thickness] WITH CHECK ADD CONSTRAINT [FK_Thickness_Layer] FOREIGN KEY([ThicknessID])
REFERENCES [dbo].[Layer] ([LayerID])
GO
ALTER TABLE [dbo].[Thickness] CHECK CONSTRAINT [FK_Thickness_Layer]
GO
ALTER TABLE [dbo].[Varieties] WITH CHECK ADD CONSTRAINT [FK_Varieties_Category] FOREIGN KEY([VCID])
REFERENCES [dbo].[Category] ([CategoryID])
GO
ALTER TABLE [dbo].[Varieties] CHECK CONSTRAINT [FK_Varieties_Category]
GO


就这些数据.帮忙转一下.
...全文

相关推荐

必须详细与全面的Java开发环境搭建图文教程

本篇文章内容包括:Linux理论与实操,MySQL实操,JDK实操,Tomcat实操和Tomcat实操,需要的朋友可以参考下

weixin_38715721

10.网站设计与开发项目技能竞赛技术方案.pdf

10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf

苦茶子12138

sqlserver向mysql迁移

本文描述了SqlServer向mysql迁移的要领以及规则

qq_16775841

C#实现连接SQL Server2012数据库并执行SQL语句的方法

主要介绍了C#实现连接SQL Server2012数据库并执行SQL语句的方法,结合实例形式较为详细的分析了C#连接SQL Server2012数据库并执行查询、插入等操作的相关实现技巧,需要的朋友可以参考下

weixin_38570278

SQL Server2012数据库备份和还原的教程

一、数据库的备份 1、选择要备份的数据库“accountInfo”,点击鼠标右键 → 任务 → 备份 2、在打开的“备份数据库 —accountInfo”对话框中,先点击删除,然后点击“添加” 3、在弹出的“选择备份目标”对话框中选择好路径和备份的文件名 4、之后在备份数据库窗口点击确定,等待备份成功 二、数据库的还原 1、在对象资源管理器中右键单击【数据库】-【还原数据库】 2、在弹出的【还原数据库】窗口,选择【设备】,并点击右侧的【…】;在弹出的【选择备份设备】窗口,点击【添加】,找到备份的文件;在【还原数据库】窗口中【目标-数据库】处输入数据库名称,并单击【确定】。 3、等

weixin_38722891
评论 5
收藏 已收藏
分享
返回顶部
1asas
MySQL 57,062 成员 56,759 内容