Accepted

Add static or "lookup" data to include in script

4 years ago • updated by 4 years ago • 2

For keeping all database design tasks in one spot, it would be useful to be able to include some amount of data inserts for lookup values. If an employee entity can have one of many role options that are stored in another table, it would be beneficial to include the data for that role table in the script SqlDBM generates.

Vote

Replies 2
Oldest first
- Newest first
- Oldest first

Under review

4 years ago

Accepted

4 years ago

Dear User,

I think this is good idea. We are glad you created this "Idea" ticket. We will discuss it with our team and work on it.

But for now, you can use "Post Script" Section of the table properties, which allow users to put any SQL (for example in your case: put Insert SQLs of your static data). And this "Post Script" SQL is spit out during Forward Engineer after the table definition.

Thank you for your assistance,

SqlDBM Team

Customer support service by UserEcho