raph93 | Code :
- CREATE TABLE "USER" (
- USER_ID int not null identity (1,1),
- USERNAME varchar(30) not null,
- PASSWORD varchar(15) not null,
- PRIMARY KEY (USER_ID));
- CREATE TABLE TOPIC (
- TOPIC_ID int not null identity (1,1),
- TITLE varchar(70) not null,
- USER_ID int not null,
- PRIMARY KEY (TOPIC_ID));
- ALTER TABLE TOPIC
- ADD CONSTRAINT fk_USER_ID FOREIGN KEY (user_id) REFERENCES "USER" (USER_ID)
- CREATE TABLE REPONSE (
- NUM_REPONSE int not null identity (1,1),
- CONTENU text not null,
- USER_ID int not null,
- TOPIC_ID int not null,
- PRIMARY KEY (NUM_REPONSE));
- ALTER TABLE REPONSE
- ADD CONSTRAINT fk_USER_ID FOREIGN KEY (user_id) REFERENCES "USER" (USER_ID)
- ALTER TABLE REPONSE
- ADD CONSTRAINT fk_TOPIC_ID FOREIGN KEY (TOPIC_ID) REFERENCES "TOPIC" (TOPIC_ID)
|
j'ai executé ce script ke je viens de creer mais kan je creé ma 2eme contrainte d'integrité sur USER_ID , l'analyseur de requete me renvoie l'erreur :
Il existe déjà un objet nommé 'fk_USER_ID' dans la base de données. |
---------------
Nothing can stop me, I'm never satisfied, I take what i want, refuse to be denied...
|