Below are simple rules for naming managed/virtual tables and the columns in a managed table.
Rules for table names
- Be at least three characters in length
- Not contain any spaces
- Contain only letters, numbers or underscores
- Table names have to be unique
- Table names are not case sensitive
Rules for column names
- Be at least three characters in length
- Not contain any spaces
- Not start with a number
- Contain only letters, numbers or underscores
- Column names have to be unique
- Column names are not case sensitive
Using table and column names, which are concise can improve the readability of SQL queries and prevent potential errors.
Comments
0 comments
Please sign in to leave a comment.