on delete cascade

Posted on 2002-11-11
Medium Priority
Last Modified: 2008-02-01
This is are sql command to create my item and customer tables.

The problem here is error

Server: Msg 156, Level 15, State 1, Line 30
Incorrect syntax near the keyword 'on'.

is appear for my item table.
Anybody can help me to solve this problem??

create table customer
(person_ID DECIMAL(10)  IDENTITY(1,1) ,
login_ID varchar(10) not null,
password varchar(10) not null,
tel_num varchar(20),
email varchar(30) ,
nama varchar(20),
primary key (person_ID))

create table item
(ref_num  DECIMAL(10) IDENTITY(1,1),
seller_ID integer not null,
state varchar(12) not null,
city varchar(15) not null,
price Money not null,
type varchar(20) not null,
primary key (ref_num) ,
foreign key (seller_ID) references customer(person_ID) on delete cascade )

Question by:melisa_
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 80 total points
ID: 7433839
MS SQL Server 7 does not support the "ON DELETE CASCADE" ...
If you have sql server 2000, then i have to look deeper
LVL 15

Expert Comment

ID: 8974134
No comment has been added lately and it seems that this question have been abandoned. So it's time to clean up this TA.

I will leave a recommendation in the Cleanup topic area that this question or invite a Moderator to close this question if there's no reply from you after seven days.

In the absence of responses, I will recommend the following:

To accept the comment and points awarded to  angelIII


Just trying to help for the cleanup...

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question