SQLServer导出数据库字典的详细图文教程（sqlserver数据库的优点）快来看

98 0 0

CREATE TABLE [dbo].[girlSix] (
[id] varchar(32) NOT NULL DEFAULT (replace(newid(),’-‘,”)) ,
[createDate] datetime NOT NULL DEFAULT (getdate()) ,
[nickName] varchar(30) NOT NULL ,
[introduce] nvarchar(200) NOT NULL
)

GO
IF ((SELECT COUNT(*) from fn_listextendedproperty(‘MS_Description’,
‘SCHEMA’, N’dbo’,
‘TABLE’, N’girlSix’,
‘COLUMN’, N’nickName’)) > 0)
EXEC sp_updateextendedproperty @name=N’MS_Description’, @value=N’名字’
, @level0type=’SCHEMA’, @level0name=N’dbo’
, @level1type=’TABLE’, @level1name=N’girlSix’
, @level2type=’COLUMN’, @level2name=N’nickName’
ELSE
EXEC sp_addextendedproperty @name=N’MS_Description’, @value=N’名字’
, @level0type=’SCHEMA’, @level0name=N’dbo’
, @level1type=’TABLE’, @level1name=N’girlSix’
, @level2type=’COLUMN’, @level2name=N’nickName’
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty(‘MS_Description’,
‘SCHEMA’, N’dbo’,
‘TABLE’, N’girlSix’,
‘COLUMN’, N’introduce’)) > 0)
EXEC sp_updateextendedproperty @name=N’MS_Description’, @value=N’介绍’
, @level0type=’SCHEMA’, @level0name=N’dbo’
, @level1type=’TABLE’, @level1name=N’girlSix’
, @level2type=’COLUMN’, @level2name=N’introduce’
ELSE
EXEC sp_addextendedproperty @name=N’MS_Description’, @value=N’介绍’
, @level0type=’SCHEMA’, @level0name=N’dbo’
, @level1type=’TABLE’, @level1name=N’girlSix’
, @level2type=’COLUMN’, @level2name=N’introduce’
GO

— —————————-
— Records of girlSix
— —————————-
INSERT INTO [dbo].[girlSix] ([id], [createDate], [nickName], [introduce]) VALUES (N’04e3d962adcb4a5b8fefaf8b46995e85′, N’2020-05-27 09:05:52.000′, N’董新颖’, N’郭老师关门弟子之一。’);
GO
INSERT INTO [dbo].[girlSix] ([id], [createDate], [nickName], [introduce]) VALUES (N’568fc305930347d3bec1ddd08c71ad29′, N’2020-05-27 09:01:09.000′, N’王笑涵’, N’北方有佳人，绝世而独立。’);
GO
INSERT INTO [dbo].[girlSix] ([id], [createDate], [nickName], [introduce]) VALUES (N’972ec358089042e0bf24fd9efca47bde’, N’2020-05-27 08:59:49.000′, N’牛龙珠’, N’笑若桃花三月开，清风徐徐醉颜来。’);
GO
INSERT INTO [dbo].[girlSix] ([id], [createDate], [nickName], [introduce]) VALUES (N’BDFFC6A36A53408281EB8CA242C0E7A3′, N’2020-05-27 08:42:31.000′, N’闫春娜’, N’珠缨旋转星宿摇,花蔓抖擞龙蛇动。’);
GO
INSERT INTO [dbo].[girlSix] ([id], [createDate], [nickName], [introduce]) VALUES (N’efb0ca854dac456b9d8c42d4c4b1bce0′, N’2020-05-27 09:03:30.000′, N’刘梓佳’, N’明眸善睐，辅靥承权，瑰姿艳逸，怡静体闲，端的是好一个花王，富贵的牡丹。’);
GO
INSERT INTO [dbo].[girlSix] ([id], [createDate], [nickName], [introduce]) VALUES (N’f839343b980e45caafaa9d2c9797294b’, N’2020-05-27 09:04:53.000′, N’魏慧娟’, N’脉脉眼中波，盈盈花盛处。’);
GO

— —————————-
— Indexes structure for table girlSix
— —————————-

— —————————-
— Primary Key structure for table [dbo].[girlSix]
— —————————-
ALTER TABLE [dbo].[girlSix] ADD PRIMARY KEY ([id])
GO

# 随心笔谈