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 |
|
maheshforum@gmail.com
Starting Member
1 Post |
 Posted - 2009-02-14 : 00:13:29
|
| Hi All, While creating the table i got the following error message, I 'm new to sqlserver so i couldn't find what it was. Help me to resolve this.my code is:-----------CREATE TABLE transactiondetail ( TRACKID varchar(3) NOT NULL, AUTOID decimal(10,0) NOT NULL, TR_TYPE varchar(2) default NULL, ACCOUNTID varchar(20) default NULL, ACC_GROUP_NAME varchar(30) NOT NULL, AMOUNT decimal(12,2) NOT NULL, TR_DATE date default NULL, TAXCODE varchar(20) default NULL, TOTALAMOUNT decimal(12,2) default NULL, KEY TRACKID(TRACKID,AUTOID), KEY ACCOUNTID(ACCOUNTID,ACC_GROUP_NAME), CONSTRAINT transactiondetail_ibfk_1 FOREIGN KEY (TRACKID, AUTOID) REFERENCES transactions (TRACKID, AUTOID) ON DELETE CASCADE, CONSTRAINT transactiondetail_ibfk_2 FOREIGN KEY (ACCOUNTID, ACC_GROUP_NAME) REFERENCES acc_group (ACC_GROUPID, ACC_GROUP_NAME) ON UPDATE CASCADE ) The error message is:---------------------Msg 156, Level 15, State 1, Line 11Incorrect syntax near the keyword 'KEY'.Thanks in advance,Mahes |
|
|
sridhar.dbe
Starting Member
34 Posts |
Posted - 2009-02-14 : 00:50:11
|
| what constraints do you want on the table??there is no key keyword in sql server. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-14 : 00:52:04
|
| did you mean primary key or unique constraint? one group you can define as primary key.other one you need to define UNIQUE constraint |
|
|
|
|
|
|
|
|
Create a table