Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lilmoore1000
Starting Member
2 Posts |
 Posted - 2012-05-01 : 01:26:11
|
| SQL> CREATE TABLE TEAMSTADIUMS 2 ( 3 S_Id INT NOT NULL PRIMARY KEY, 4 S_NAME VARCHAR(20), 5 T_ID INT FOREIGN KEY REFERENCES MLBTEAMS(T_ID) 6 );T_ID INT FOREIGN KEY REFERENCES MLBTEAMS(T_ID) *ERROR at line 5:ORA-00907: missing right parenthesisi am a complete noob to SQL and i cant figure out where the missing right parenthesis goes :( |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-01 : 01:29:39
|
| This is an Oracle error . You're on a SQL server forum. www.dbforums.com cover Oracle questionsJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Error in Create Table command