增
INSERT INTO TableName() VALUES()
删
DELETE FROM TableName
DROP TableName
改
UPDATE TableName SET 字段=""
修改数据类型
ALTER TABLE TableName
ALTER COLUMN ColName varchar(50)
备份表
SELECT * into TABLE_NEW
FROM TABLE_OLD
增
INSERT INTO TableName() VALUES()
删
DELETE FROM TableName
DROP TableName
改
UPDATE TableName SET 字段=""
修改数据类型
ALTER TABLE TableName
ALTER COLUMN ColName varchar(50)
备份表
SELECT * into TABLE_NEW
FROM TABLE_OLD