Reversing SQL script files

The SQL reverse

The SQL Designer module provides reverse features for SQL script files limited to the database schema (they use the data definition language), in other words “CREATE TABLE”, “ALTER TABLE” and “DROP TABLE”.
The SQL Designer module recognizes four grammars according to the data definition language being used (Oracle11g, Mysql, Sqlserver2008, SQL92 and Firebird).
The data definition language is used to declare a database such as the creation of tables and the addition of constraints.

We have the following types of declaration:
«CREATE TABLE TEST_TABLE_NOM(NOM VARCHAR(25),PRENOM VARCHAR(30))»
«ALTER TABLE TEST_TABLE_NOM ADD ADRESSE VARCHAR(50)»
Neither the data manipulation language nor the data control language is managed.

Reversing an SQL script file

To reverse an SQL script file:

2

The “Reverse: SQL Script” command of the SQL Designer module

3

Window in which you can enter the path of the file to be reversed