How is the name of a table alias determined ?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Does anyone know what factors determine how the table alias gets created?  Does it follow the below:

* first name given to a new table (names can be very long too)

* spaces are replaced with underscores  _ 

* prefixed with _dbid_

* additional similar names changed to _table_1 where 1 increments

* non-alphacharacters converted to underscores _  like @ # ! $

* tables starting with a number get prefixed with an extra space.


I'm not really wanting to do anything, other than curiousity on that right now.


http://www.quickbase.com/user-assistance/what_is_an_alias.html?_ga=1.xxxxxxxxx.1695311132.1454335275

Photo of Ryan

Ryan

  • 200 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb
I think you pretty much nailed it except that table aliases appear to be case insensitive:

[_dbid_table_1]

OR

[_DBID_Table_1]

Photo of Gaurav

Gaurav

  • 50 Points
Can we get table names from table aliases?? Or can we rename the table aliases?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb
The formula language does not have any function that returns the table name. You can not rename the table alias as it is permanently set when the table is created.
Photo of Gaurav

Gaurav

  • 50 Points
I have to show all the table names present in my app in a dropdown. I am able to show table aliases in dropdown but some aliases names are like table_1 which make no sense about the table name. Can u suggest some alternate for this?