1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| 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'
|
|