IntelliJ IDEA
 
2024.3
Get IntelliJ IDEA

DDL mappings

Last modified: 04 December 2024

DDL mapping functionality sets the relation between the regular data source and the DDL data source. By using mapping, you can explicitly select schemas in the real data source to synchronize objects with the DDL data source. And, alternatively, any changes in the DDL data source can be applied to a regular data source.

For example, you can create the actor_1 table in your PostgreSQL data source, and later by using the DDL Mapping | Update from PostgreSQL action in the context menu, add the actor_1.sql file to your DDL data source folder with SQL files. Or, add actor_1.sql file to the DDL data source, select DDL Mapping | Apply to PostgreSQL in the context menu, and the actor_1 table will appear in the PostgreSQL data source.

DDL Mappings tab in the Data Sources and Drivers dialog