StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Can not set self relationship

Can not set self relationship

fookyean — Thu, 08 Jun 2006 10:26:12 GMT

I try create the a table that has relationship with table itself, but DDT do not allows.:unsure:

For example, Employee Table that has emp_pk as PK and emp_superiorpk as a foreign key that refer to the superior pk refer to the Employee Table as well as below:

employee (1)---> (0,m) employee

How I can create this in DDT ?

RE: Can not set self relationship

StrataFrame Team — Thu, 08 Jun 2006 10:26:12 GMT

The update has been posted in the MyAccount area.

RE: Can not set self relationship

StrataFrame Team — Thu, 08 Jun 2006 08:51:01 GMT

Ah, I didn't even realize that that was a business rule in the DDT. It's certainly allowed in SQL Server, so I removed the rule, and you will be able to do it in the next version that will be released here in a few hours.