1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
| ALTER TABLE [dbo].[mom_eam_equipment_report_repair] DROP CONSTRAINT [DF__mom_eam_e__err_u__00AD44A9]
| GO
|
| ALTER TABLE [dbo].[mom_eam_equipment_report_repair] ALTER COLUMN [err_uda5] text NULL
| GO
|
| IF ((SELECT COUNT(*) FROM ::fn_listextendedproperty('MS_Description',
| 'SCHEMA', N'dbo',
| 'TABLE', N'mom_eam_equipment_report_repair',
| 'COLUMN', N'err_uda5')) > 0)
| EXEC sp_updateextendedproperty
| 'MS_Description', N'验收意见',
| 'SCHEMA', N'dbo',
| 'TABLE', N'mom_eam_equipment_report_repair',
| 'COLUMN', N'err_uda5'
| ELSE
| EXEC sp_addextendedproperty
| 'MS_Description', N'验收意见',
| 'SCHEMA', N'dbo',
| 'TABLE', N'mom_eam_equipment_report_repair',
| 'COLUMN', N'err_uda5'
| ALTER TABLE [dbo].[sys_user] ADD [area_id] nvarchar(32) NULL
| GO
|
| EXEC sp_addextendedproperty
| 'MS_Description', N'中心ID',
| 'SCHEMA', N'dbo',
| 'TABLE', N'sys_user',
| 'COLUMN', N'area_id'
|
|
