摘要: http://www.w3school.com.cn/sql/1:复制 column1列的内容给column2的语法update table1set column2 = column2goxxx2:删除主键约束--tablename 表名 --PK__EXauditingmaster__300424B4 主键约束名alter table [tablename] drop CONSTRAINT [PK__EXauditingmaster__300424B4]go3:添加主键约束alter table [tablename] add Constraint PK_name Primary Key ( 阅读全文
posted @ 2011-03-03 14:07 infi 阅读(306) 评论(0) 推荐(0)