Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Other Development Tools  Using SQLDMO to Manage Keys

Author  Topic  wspguy Starting Member 1 Post Posted - 2005-06-21 : 12:48:40 I am having trouble determining how to set the Cascading Update/Delete on a Key. I can know how to set the referenced table and fields. But I can't find the property/method to set this up. Here is a snippet... Dim dmoKey As SQLDMO.Key dmoKey.ReferencedTable = "table_nm" for each fld in Fields dmoKey.ReferencedColumns.Add fld next . . I just can't find out how to do this... [checkbox] Enforce relationship for INSERTs and UPDATEs wspguy websitepipeline™ - revolutionizing website development www.websitepipeline.com