SQL query where Alias longer than 64 characters gives error 'Name is empty'

Question

Hi There,

I have an sql database with quiet long table names, many of them are longer than 64 characters which is causing issues. I can add the tables to the map by right clicking and selecting add to map but if I try to add them using the Add Data>Query Layer tool, or if I add them and then try to modify the query using the Query Layer tool I get an error saying 'Name is empty' and the query will not validate.

The documentation states that tables names of up to 128 characters from SQL are allowable which would be fine but in this case the limit appears to be 64 characters?

I am using ArcPro 2.9 and SQL Server 14.

Any help gratefully received!

George_Thompson · Answer

Ok, I would contact support on this.

DeirdreODriscoll · Answer

It is a SQL server spatial database.

George_Thompson · Answer

Thanks for that additional information. It may be best to work with Technical Support on this.

Is the database a geodatabase or just a SQL Server spatial database (i.e. repository tables)?