drop table ANNUAIRE ; /* erreur si n'existe pas ce qui n'est pas grave */

create table ANNUAIRE(
	ident int primary key,
	Nom char(20),
	Prenom char(20),
	telephone char(14)
);

Insert into ANNUAIRE values (1,'A','a','05');
Insert into ANNUAIRE values (2,'B','b','05');
Insert into ANNUAIRE values (3,'C','c','05');
Insert into ANNUAIRE values (4,'D','d','05');
Insert into ANNUAIRE values (5,'E','e','05');
Insert into ANNUAIRE values (6,'F','f','05');
Insert into ANNUAIRE values (7,'G','g','05');


