I'm creating a relational database schema that might be ported to multiple database platforms--SQLite3, PostgreSQL and MySQL and perhaps others.

I must create table names that might be portable across all of the database platforms. What exactly are naming limitations must i follow?

  • What figures are permitted?
  • What figures are permitted to start the title?
  • What's the maximum length?
  • Exist other limitations I should know?

Thanks

/^[a-zA-Z][a-zA-Z0-9_]{,9}$/ is usually safe.