alter table 2.zip_ALTER_Table_csharp_sql

use vente select * from t2 create table t2(a int default 0,b int,ch varchar(50) default 'chaine defaut') insert into t2 values(3,3,default) insert into t2 values(4,4,'123',4) -------------------------------- alter table t2 add c int not null default 2 alter table t2 add d varchar(50) alter table t2 alter column b varchar(50) alter table t2 alter column d int alter table t2 add constraint cte default (2) for a --si contrainte default n'existe pas d�j� --alter table t2 alter column a set default (2) sql serveur compact seulement alter table t2 alter column c int null alter table t2 drop column d select cast(CH as int) from t2 delete from t2 alter table t2 add rr int unique create table t3(f int) alter table t3 add z int primary key alter table t3 add e int unique check(e>10) create table t4(g int) alter table t4 add d int default 2 primary key insert into t4(g) values(2)