How to make table DDL read only

Answered

The DDL of a table can be modified but changes won't be executed. However, the DDL will remain changed even if the database is refreshed. If the DDL is accidentally edited and the user forgets the change, the user will read wrong DDL. How to make DDL read-only to prevent this from happening?

3 comments
Comment actions Permalink

Have you linked the DDL to the actual data source? 

Does the "Warn when editing outdated DDL" checkbox fits your case? 

See https://www.jetbrains.com/help/datagrip/data-sources-and-drivers-dialog.html#optionsTab

0
Comment actions Permalink

Yes, the checkbox was selected but there was no warning.

0
Comment actions Permalink

Have you linked the DDL to the actual data source? 

0

Please sign in to leave a comment.