一、修改表名
修改表名:EXEC sp_rename ‘原有表名’, ‘新表名’;exec sp_rename 'boooks','books';
二、修改列名
修改列名:EXEC sp_rename ‘表名.[原有列名]’, ‘新列名’ , ‘COLUMN’;exec sp_rename 'People.[PeopleBirthday]','PeopleBirth','column';
一、修改表名
修改表名:EXEC sp_rename ‘原有表名’, ‘新表名’;exec sp_rename 'boooks','books';
二、修改列名
修改列名:EXEC sp_rename ‘表名.[原有列名]’, ‘新列名’ , ‘COLUMN’;exec sp_rename 'People.[PeopleBirthday]','PeopleBirth','column';