摘要： 用SQL语句添加删除修改字段0,已有字段设置为主键并自增alter table House_HK_TEST_2013 drop column HouseIDalter table House_HK_TEST_2013 add HouseID int identity(1,1)ALTER TABLE House_HK_TEST_2013 ADD PRIMARY KEY (HouseID);1.增加字段alter table docdspadd dspcodechar(200)增加字段alter table LoanApplication add LoanType int default 1--. 阅读全文