1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
drop table autonum;
go
create table autonum
(
id int primary key,
nom varchar(10) not null
);
go
insert into autonum (id, nom) values (1, 'toto');
insert into autonum (id, nom) values (2, 'titi');
insert into autonum (id, nom) values (4, 'tutu');
go
sp_RENAME 'autonum' , 'old_autonum';
go
create table autonum
(
id int primary key identity,
nom varchar(10) not null
);
go
set IDENTITY_INSERT autonum on;
insert into autonum (id, nom)
select id, nom from old_autonum;
set IDENTITY_INSERT autonum off;
go
drop table old_autonum;
go
insert into autonum (nom) values ('tata');
go
select * from autonum; |
Partager