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.

1 Comment
Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox