lyfz_repos/经典版源码/document/数据库维护脚本/修改dindansp表属性.sql

--dindansp±í;
use [db]

alter table [dindansp] alter column	[id] [nvarchar](50) NULL
alter table [dindansp] alter column	[spid] [nvarchar](20) NULL
alter table [dindansp] alter column	[shuliang] [nvarchar](120) NULL
alter table [dindansp] alter column	[kind] [nvarchar](10) NULL
alter table [dindansp] alter column	[price] [nvarchar](50) NULL
alter table [dindansp] alter column	[name] [nvarchar](50) NULL
alter table [dindansp] alter column	[no] [nvarchar](max) NULL
alter table [dindansp] alter column	[status1] [nvarchar](10) NULL
alter table [dindansp] alter column	[status2] [nvarchar](10) NULL
alter table [dindansp] alter column	[status3] [nvarchar](50) NULL
alter table [dindansp] alter column	[status4] [nvarchar](50) NULL
--alter table [dindansp] alter column	[autoid] [int] IDENTITY(11) NOT NULL--²»ÐèÒªÐ޸ĴË×Ö¶Î;
alter table [dindansp] alter column	[date1] [nvarchar](20) NULL
alter table [dindansp] alter column	[date2] [nvarchar](20) NULL
alter table [dindansp] alter column	[date3] [nvarchar](20) NULL
alter table [dindansp] alter column	[date4] [nvarchar](20) NULL
alter table [dindansp] alter column	[name1] [nvarchar](50) NULL
alter table [dindansp] alter column	[name2] [nvarchar](50) NULL
alter table [dindansp] alter column	[name3] [nvarchar](50) NULL
alter table [dindansp] alter column	[name4] [nvarchar](50) NULL
alter table [dindansp] alter column	[hqdate] [nvarchar](50) NULL
alter table [dindansp] alter column	[hqtime] [nvarchar](50) NULL
alter table [dindansp] alter column	[urgent] [nvarchar](50) NULL
alter table [dindansp] alter column	[taketime] [nvarchar](50) NULL
alter table [dindansp] alter column	[no2] [nvarchar](max) NULL
alter table [dindansp] alter column	[status5] [nvarchar](50) NULL
alter table [dindansp] alter column	[status6] [nvarchar](50) NULL
alter table [dindansp] alter column	[date5] [nvarchar](50) NULL
alter table [dindansp] alter column	[date6] [nvarchar](50) NULL
alter table [dindansp] alter column	[name5] [nvarchar](50) NULL
alter table [dindansp] alter column	[name6] [nvarchar](50) NULL
alter table [dindansp] alter column	[growthtxname] [nvarchar](50) NULL
alter table [dindansp] alter column	[ps] [nvarchar](50) NULL
alter table [dindansp] alter column	[zs] [nvarchar](50) NULL
alter table [dindansp] alter column	[ren1] [nvarchar](120) NULL
alter table [dindansp] alter column	[ren2] [nvarchar](120) NULL
alter table [dindansp] alter column	[hqstatus] [nvarchar](50) NULL
alter table [dindansp] alter column	[bz] [nvarchar](200) NULL

/*
if not exists(select name from syscolumns where id=object_id('dindansp') and name='ren1') alter table [dindansp] add [ren1] [nvarchar](120)null
if not exists(select name from syscolumns where id=object_id('dindansp') and name='ren2') alter table [dindansp] add [ren2] [nvarchar](120)null
if not exists(select name from syscolumns where id=object_id('dindansp') and name='hqstatus') alter table [dindansp] add [hqstatus] [nvarchar](50)null
if not exists(select name from syscolumns where id=object_id('dindansp') and name='bz') alter table [dindansp] add [bz] [nvarchar](200)null
*/
go