Create Table Link using T-SQL

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Hicks SSC Enthusiast Points: 101 More actions · Answer 1

SSC Enthusiast

Points: 101

March 22, 2004 at 1:39 am

Hi,

Table link?? U mean relationship right??

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 2

Thanks for the prompt reply

Yes it is regarding a relationship

My Blog: http://dineshasanka.spaces.live.com/

Steve Hicks SSC Enthusiast Points: 101 More actions · Answer 3

Hi,

When you define the relationship add:

ON DELETE CASCADE or ON UPDATE CASCADE

onto the end of the constraint definition.

Hope this helps.

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 4

Thankx Steve Hicks for the promt help

My Blog: http://dineshasanka.spaces.live.com/