Downloads Home
Extract SQL Feature Matrix

Extract SQL have many different functions depending on the selected node on the tree view.
Here is a matrix describing what you can expect if you execute EXTRACT SQL

Selected node on the tree Action
Database Disabled
 
Table
  • The CREATE TABLE SQL with all the fields
  • Comments on the table and fields
  • User rights on the table
  • Constraints - Foreign Keys
  • CHECK Definitions on fields
  •  
    Table fields Disabled
     
    Rules if exist on table DROP AND CREATE RULE
     
    Triggers Folder Disabled
     
    Triggers
  • Action Trigger - Drop Trigger, Drop Function, Create Function, Create Trigger
  • Named Constraint Trigger (Foreign Key) Drop All Triggers,ALTER TABLE to recreate constraint
  • unnamed Constraint Trigger - Warning - Assumption (Guess) of the triggers to be dropped - ALTER TABLE SQL
  •  
    Index Folder Disabled
     
    Specific Index
  • If the index is a Primary Key - DROP INDEX, Alter table SQL (7.2)
  • If the index is a Primary Key - DROP INDEX, CREATE INDEX UNIQUE (<7.1.3)
  • Normal Index - DROP INDEX, CREATE INDEX
  •  
    Sequence Folder Disabled
     
    Sequence DROP AND CREATE Sequence
     
    Owner Folder Disabled
     
    Comments Folder Disabled
     
    User Folder All User permission on table
     
    Specific User Disabled - Please use wizard new in 1.07