&*%&**$!! - what is this syntax???

[katgirl]

Am I the only person who finds BOL's syntax diagrams undecipherable???

What am I doing wrong here?? ARgggghhhhh

ALTER TABLE myTable ADD myForeignKeyName FOREIGN KEY (column name) REFERENCES PKTable (column name)

 

[gmmastros]

Try...

ALTER TABLE myTable ADD [!]constraint[/!] myForeignKeyName FOREIGN KEY (column name) REFERENCES PKTable (column name)

You're not the first to be bothered by the documentation. Often times, it's better to scroll down to the examples. In this case, the examples aren't that helpful either.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[katgirl]

thanks george -