powerdesign 生成SQLserver2018语句的修改

红框中的替换为下图即可执行成

mysql 成功表：

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `bb_sort`
-- ----------------------------
DROP TABLE IF EXISTS `bb_sort`;
CREATE TABLE `bb_sort` (
  `id` varchar(64) NOT NULL COMMENT '编号',
  `uid` varchar(64) DEFAULT NULL COMMENT '用户标识',
  `sort_name` varchar(255) DEFAULT NULL COMMENT '分类名称',
  `sort_img` varchar(255) DEFAULT NULL COMMENT '分类图标',
  `priority` int(3) DEFAULT NULL COMMENT '优先权',
  `income` tinyint(1) NOT NULL COMMENT '支出收入标识',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '备注信息',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '删除标记',
  `object_id` varchar(50) DEFAULT NULL COMMENT '唯一标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;

　　

SQLserver成功表

USE [jeesite]
GO

/****** Object:  Table [dbo].[bb_sort]    Script Date: 2019/7/6 下午9:36:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[bb_sort](
	[id] [varchar](64) NOT NULL,
	[uid] [varchar](64) NULL,
	[sort_name] [varchar](255) NULL,
	[sort_img] [varchar](255) NULL,
	[priority] [int] NULL,
	[income] [tinyint] NOT NULL,
	[create_by] [varchar](64) NULL,
	[create_date] [datetime] NULL,
	[update_by] [varchar](64) NULL,
	[update_date] [datetime] NULL,
	[remarks] [varchar](255) NULL,
	[del_flag] [char](1) NOT NULL,
	[object_id] [varchar](50) NULL,
PRIMARY KEY NONCLUSTERED 
(
	[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

ALTER TABLE [dbo].[bb_sort] ADD  DEFAULT ('0') FOR [del_flag]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'uid'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分类名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'sort_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分类图标' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'sort_img'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'优先权' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'priority'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支出收入标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'income'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'create_by'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'create_date'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'update_by'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'update_date'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'remarks'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'del_flag'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'唯一标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bb_sort', @level2type=N'COLUMN',@level2name=N'object_id'
GO