The syntax is descibed in BOL. To get a sample code, create a constrain in the EM and then generate script.

>You wouldn't know the syntax by chance, would you? (silly question ofcourse you do <s>)
>I am being a little lazy, could you please post the code?
>

>
>>You can do it either in the Enterprise Manager (EM) or using ALTER TABLE command if table already exists or CREATE TABLE otherwise.