ER Diagram, Generate DDL
The CREATE TABLE statements generated from Generate DDL option, should also include foreign key columns in the child tables.
For e.g. If 'deptid' is a foreign key from 'Departments' table (i.e. parent) in 'Employee' table (i.e. child), column 'deptid' also should be automatically included in the CREATE TABLE Employee statement. Appropriate foreign key constraint statement also should be mentioned at the end. Thanks.
7
votes
Girish
shared this idea