Rules for table names

[Piet_Strydom]

Hi All,

Quick question:

Is there a “prohibition” against starting tables names with numbers? Before I added SCE in front of the table names, the table names would not pop up in the formula builder.

Regards
Piet

[Thierryvm]

Hello @Piet_Strydom

,

There doesn’t seem to be any rule preventing it, at least if you use the right syntax. 001_sce_DB etc…

Sincerely,

Thierry

[Piet_Strydom]

yeah, I can create tables with names starting with numericals, but they do not appear as selectable object in the formula builder.

I am not certain whether it is a bug or a feature.

P

[Scott_Collier-Weir]

Its been like that ever since I can remember. Same thing for column names.

I think its a bug, because if you type the entire thing in to your formula builder character for character it is recognized

[Piet_Strydom]

And as always, I break things even further:

Coda interprets my date as 2022 Minus 5 Minus 26…