maker.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

BEGIN
CREATE TABLE [dbo].[gly]([glyid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[zcsj] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注册时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'zcsj'
BEGIN
CREATE TABLE [dbo].[khjl]([khjlid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[lxdz] [VARCHAR](40),
[lxdh] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'khjl', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'khjl', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'khjl', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'khjl', @level2type=N'COLUMN', @level2name=N'lxdz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'khjl', @level2type=N'COLUMN', @level2name=N'lxdh'
BEGIN
CREATE TABLE [dbo].[khdj]([khdjid] [int] IDENTITY(1,1) NOT NULL,
[dj] [VARCHAR](40),
[sm] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'等级' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'khdj', @level2type=N'COLUMN', @level2name=N'dj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'khdj', @level2type=N'COLUMN', @level2name=N'sm'
BEGIN
CREATE TABLE [dbo].[kehu]([khid] [int] IDENTITY(1,1) NOT NULL,
[khmc] [VARCHAR](40),
[xb] [VARCHAR](40),
[nl] [VARCHAR](40),
[zy] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[jtzz] [VARCHAR](40),
[dw] [VARCHAR](40),
[yx] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kehu', @level2type=N'COLUMN', @level2name=N'khmc'
GO