wrong syntax ?

22/08/2008 - 19:12 von Eddy | Report spam
where is in this example a syntax error:

Alter Table uombase Add Constraint unit_of_measure_schedule_conversions
Foreign Key uomscheduleid References uomschedulebase uomscheduleid;

I get this error-Message:

Meldung 102, Ebene 15, Status 1, Zeile 2
Falsche Syntax in der Nàhe von 'uomscheduleid'.

Every commands are welcome.
 

Lesen sie die antworten

#1 Christoph Ingenhaag
22/08/2008 - 20:11 | Warnen spam
Hi Eddy

this will work:

alter table uombase add constraint unit_of_measure_schedule_conversions
foreign key (uomscheduleid) references uomschedulebase (uomscheduleid);

btw, this is a german newsgroup...

Vg
Christoph

Ähnliche fragen