Sample Header Ad - 728x90

How can I import Create Table Statement from SQL Developer into Visio to create an Entity Relationship Diagram?

1 vote
1 answer
1069 views
I have the following Create table statement from SQL Developer and I am trying to generate an ERD Diagram using 2003 Visio. I was wondering what I need to do to convert the Create Table from SQL Developer to an ERD Diagram Using Visio. CREATE TABLE “TT_TEAM”.”HR_REVOKED_SECURITY_ORGS” ( “ID” NUMBER NOT NULL ENABLE, “ACAT_CODE” VARCHAR2(6 BYTE) NOT NULL ENABLE, “APPR_SEQ_NO” NUMBER(3,0) NOT NULL ENABLE, “USER_ID” VARCHAR2(30 BYTE) NOT NULL ENABLE, “ACTION_IND” VARCHAR2(1 BYTE) NOT NULL ENABLE, “ACTIVITY_DATE” DATE NOT NULL ENABLE, “COAS_CODE” VARCHAR2(1 BYTE), “ORGN_CODE” VARCHAR2(6 BYTE), “POSN” VARCHAR2(6 BYTE) NOT NULL ENABLE, “MANDATORY_APPR_IND” VARCHAR2(1 BYTE), “APPR_POSN” VARCHAR2(6 BYTE), “ORGN_MANAGER” VARCHAR2(6 BYTE) NOT NULL ENABLE;
Asked by mayo fadelu (11 rep)
Aug 7, 2012, 03:29 PM
Last activity: Oct 7, 2012, 01:04 PM