- This topic has 3 replies, 4 voices, and was last updated 19 years, 5 months ago by
.
-
Posts
-
When I generate a script that creates the table from the table, I get no foreign key constraints generated. Am I doing something wrong?
Posted for a user that had trouble posting. Please reply to thread.
When I generate a script
You wrote a custom script?
that creates the table from the table
I don’t understand this.
Am I doing something wrong?
Can’t tell yet, I have no idea what you are trying to do.
I think what the user is saying is: “When I right-click a table in the DBX Browser, and select ‘CreateTable Script’, the script generated in the SQLEditor contains no constraints that are defined on the table in the database.” Is this the case?
Regardless, this is a bug that has been in the DBX plugin forever it seems. The action generating the script takes a seriously simplistic approach (no constraints, except for PK, and then only for simple one column PK). I will file in bugzilla.
@support-jeff wrote:
I think what the user is saying is: “When I right-click a table in the DBX Browser, and select ‘CreateTable Script’, the script generated in the SQLEditor contains no constraints that are defined on the table in the database.” Is this the case?
Regardless, this is a bug that has been in the DBX plugin forever it seems. The action generating the script takes a seriously simplistic approach (no constraints, except for PK, and then only for simple one column PK). I will file in bugzilla.
Yes Jeff. That is exactly what I was trying to say. Thank you.
