# Schema Generation

This table lists the properties of the Schema Generation page of the persistence.xml Editor.

Note: This page is not available for projects using the Generic platform.

Property | Description | Default
--- | --- | ---

DDL Generation Type

Select the type of DDL generation:

- None -- Do not generate DDL; no schema is generated.

- Create Tables -- Create DDL for non-existent tables; leave existing tables unchanged.

- Drop and Create Tables -- Create DDL for all tables; drop all existing tables.

None

Output Mode

Select the DDL generation target:

- Both -- Generate SQL files and execute them on the database.

- Database -- Execute SQL on the database only (do not generate SQL files).

- SQL Script -- Generate SQL files only (do not execute them on the database).

DDL Generation Location | Specify where EclipseLink writes DDL output. Specify a file specification to a directory in which you have write access. The file specification may be relative to your current working directory or absolute. If it does not end in a file separator, then EclipseLink appends one that is valid for your operating system. |
Create DDL File Name | Specify the file name of the DDL file that EclipseLink generates that contains SQL statements for creating tables for JPA entities. Specify a file name valid for your operating system. | `createDDL.jdbc`
Drop DDL File Name | Specify the file name of the DDL file that EclipseLink generates that contains SQL statements for dropping tables for JPA entities. | `dropDDL.jdbc`

Related references

- Java Persistence API (JPA) Extensions Reference for EclipseLink
  `http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/toc.htm`