I'm exporting my last weeks relational model project to DDL in hopes of getting a quick accurate way to create my 17 tables. In the relational model, Cust_ID is the PK Yet there is nothing indicating it in the script that is created from the export to DDL File. This is what it created. Now when I right click on the customer table in the relational model view, and then pick DDL preview, it adds the alter table line. But when I do that for most of the opther tables including the phones table in the picture below, it's just the fields, no PK or PK info. How do I get the PK and FK's to show up? Thanks, Peter
CREATE TABLE Customer
(
Cust\_ID INTEGER NOT NULL ,
Name VARCHAR2 (128) ,
Address VARCHAR2 (128 CHAR)
) ;
ALTER TABLE Customer ADD CONSTRAINT Customer_PK PRIMARY KEY ( Cust_ID ) ; <------This only shows up in the DDL Preview, not in export to DDL File. The phone table doesn't show any constraints or keys in either view. Same with almost all tables.
This is what I get for phones
CREATE TABLE Phones
(
Phone\_ID INTEGER NOT NULL ,
Phone\_Type NVARCHAR2 (10) ,
Phone\_Number CHAR (14) ,
Customer\_Cust\_ID INTEGER NOT NULL
) ;
