改列的格式:alter table tablename alter column columnname nvarchar(20)
删除一列:alter table tablename drop column columnname;
增加一列:alter table tabelname add columnname varchar2(8) NULL;
SQL对表字段的增,删,改
最新推荐文章于 2023-07-05 13:15:30 发布
改列的格式:alter table tablename alter column columnname nvarchar(20)
删除一列:alter table tablename drop column columnname;
增加一列:alter table tabelname add columnname varchar2(8) NULL;