Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
New to SQL DDL - Having Foreign Key issues
Thanks everyone for the help , it was that I had no column name to reference the foreign key in the table as SQLSister pointed out. Thanks again for the quick response , new to SQL and databases and learning all of the time. Regards Eoin -
New to SQL DDL - Having Foreign Key issues
Thank you for the response, but being new to this the next question will probably irritate you. This is code that works [example code]… how is this different from what I am trying to do? CREATE TABLE DEPT ( DEPTNO NUMBER(2) NOT NULL, DNAME CHAR(14), LOC... -
New to SQL DDL - Having Foreign Key issues
Hi, I am trying to code my database [Oracle], but am coming across a problem that I cannot figure out. The code below gives the following error Table dropped. Table created. Table created. CONSTRAINT ACCOM_res_id_fk FOREIGN KEY (res_id) REFERENCES RESORT (res_id...
