Validation of names against SQL keywords and database restrictions
- Last Updated: February 19, 2021
- 1 minute read
- Corticon
- Documentation
Commercial databases, such as Microsoft SQL Server and Oracle, use specific words for defining, manipulating, and accessing databases. These reserved keywords are part of the grammar used to parse and understand statements. Do not use database reserved words for Corticon Entity, Attribute, and Association names when creating the schema in Corticon. Your database support pages list reserved words—for example, Microsoft's Reserved Keywords—that you should review as you prepare your Vocabulary for enterprise data connection.
Corticon makes a best-effort to validate the names against the SQL keywords against the database restrictions for column and table naming (such as length of a table name), and then validates generated column names (such as Foreign Key (FK) columns) against SQL keywords and table/column name restrictions.