Last active
October 7, 2020 11:09
-
-
Save leo-from-spb/5c834e232da46c3eed09ef1b591509cb to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
When a user write a database creation script, they give names for most of database objects (i.e. table names, | |
column names, constraint names, etc). When the DB author performs this script using a DBMS it creates a database | |
that contains objects with the names specified in the script. If the author perfroms this script several times, | |
the result will be several database with the same object names (as specified in the script). | |
However, sometimes the DB author can omit some names (i.e. names of constraints, indices, etc.), in this case | |
the DBMS makes names for these objects automatically (usually by concatenating a hardcoded prefix with a kind of | |
random or sequential number). When the author performs their script several times, the result will be databases | |
with different names (because that names were not specified in the script). We call such auto-genertated names | |
synthetic ones. So, the mentioned option includes such auto-generated stuff. | |
In other words, when this option is OFF, the content in the window depends on objects and names | |
coded by the DB author only (and will be always the same), when this option is ON the content | |
iuncludes also the stuff generated by DBMS automatically (and can be different for several databases | |
produced by the same script). |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment