I'm sure that the answer to this is going to be "It's always done this", and to be honest, I'd even accept a "does it really matter?". But anyway ...

If I use the DataFlex studio to create a new MSSQL table, the resulting SQL table name matches the text as I entered it in the studio. "MyNewTable" becomes "dbo"."MyNewTable". Likewise if I create "MyNewTable" as an embedded table and subsequently migrate it using the Studio's conversion wizard, the name casing is also preserved.

However, if instead I create the table using code and Structure_Start / Structure_End, the resulting table name in the SQL database is always uppercased. "MyNewTable" becomes "dbo"."MYNEWTABLE".

Any particular reason for this? Any chance that the behaviour could be changed and the case preserved?


I'm using DF 19.1 Beta 1 but I suspect it's just always been like this. (It's just a little bit annoying). Or is this where someone tells me that there is a setting somewhere I've not found ...