This time I used pd to design the database. I didn’t pay attention at first. All table names and field names are in lowercase letters. As a result, all the objects in the generated script were quoted, so I didn’t want to change so many tables and fields one by one, so I looked for a solution, and the result was really found (it seems that pd only supports uppercase and lowercase by default) The table name or field will be automatically quoted in the script )< br>
Database->Edit current database->Script->Sql->Format , there is one item CaseSensitivityUsingQuote , its comment < span style="margin:0px; padding:0px; font-family:宋体; font-size:14px">为 “Determines if the case sensitivity for identifiers is managed using double quotes” , indicating whether double quotes apply The case of the identifier can be seen on the right side values The default value is “YES”, Change to “No” That’s it!