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.
To reverse an SQL script file: