Is it possible to build create sql script of multiple tables?

Tell us what features you'll want
Post Reply
maj2c
Posts: 1
Joined: Wed Jul 12, 2017 1:34 pm

Is it possible to build create sql script of multiple tables?

Post by maj2c » Wed Jul 12, 2017 1:46 pm

Hi,

By right clicking a table and chosing "Build SQL" => "Create statement" from the contexual menu a script of create table and all its indices, triggers and foreign keys references is created. But when selecting more tables the option is removed from the contexual menu.
Is it possible to add the create statement feature to a selection of tables or group of tables? Or can this be achieved in a different way I did not come accross yet?

Regards,
Maj

support
Posts: 53
Joined: Tue Dec 01, 2015 8:44 am

Re: Is it possible to build create sql script of multiple tables?

Post by support » Thu Aug 17, 2017 6:21 am

Hi Maj,
You can select the tables in the layout ( keep Ctrl pressed and click the headers ). Then go in the menu and choose Schema / Generate schema script. In the second dialog you will have a tree selection with this tables already marked.

Post Reply