dbeaver / dbeaver/dbeaver

Export DDL for many objects

Open
#5,693 8 comments 21 reactions 0 assignees View on GitHub
xf:metadata xf:navigator xf:sql
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

Hi,
I'd like to be able to export DDL for many objects, each object to his own file.
Currently I'm able to select them in Database Navigator and use Generate SQL -> DDL from context menu.
This however allows me to copy to clipboard a single script containing all objects; a nice feature would be to be able, through some other means, to be able to export ddl to separate files in a directory of my choosing.
This applies to all objects for which DDL is available (tables, views, procedures, etc) and to all databases.

For tables, the export wizard should allow to choose DDL options (Full DDL, no storage information, Compact form), however this might be a separate request.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.