Rules for naming managed tables

SolveXia provides simple way to create an SQL table on SolveXia system and store large amount of data. It is called “Managed table”. Read this article on how to create a managed table in SolveXia platform. Below are simple rules for naming managed table and columns name in managed table.

Rules for table name

  1. Table name must be at least 3 characters long
  2. Table name cannot have leading or trailing white space
  3. Table name can only consist of letters, numbers, space or underscores
  4. Table name cannot consist of any special character, such as %, &, * etc.

 

Rules for columns name
  1. Column name must be at least 3 characters long
  2. Column name cannot have leading or trailing white space
  3. Column name can only consist of letters, numbers, space or underscores
  4. Table name cannot consist of any special character, such as %, &, * etc.

 
Using simplified table name and columns name improves quality of SQL queries and prevents potential errors in SQL queries.

Recommended Posts
Comments
pingbacks / trackbacks
  • […] the table name of your choice (Refer to rules for table name) 8. Click on ‘Add‘ link to add columns one by one OR enter numbers of columns you like […]

Leave a Comment