Is it bad to name a column in an SDE table with a pound sign? For example: #_Conduit or #_Feature
Ok! Thank you!
You might want to clean up your data now (take the pain) and remove the # signs before you get deep into building/configuring your web applications where it might become much more difficult (painful) to clean your data with dependent apps hanging off non Best Practice data sets.
Thanks, I did read that and it makes no mention of the #. So maybe it will be ok!
Check Character type limits in object names - Enterprise geodatabase size and name limits—ArcGIS Help | ArcGIS for Desktop
Thanks. The geodatabase already has feature classes in it set up with column names that start with #. This was done a while back before i got here. Now i will be designing a web application using the tables with column names that start with the #. I was worried it might make queries act strange?
Hi Robert, Generally it is not a recommended practice to use special characters in a field/column name. The names should give an indication of what data is contained in that particular column.
Below would be a few web links for your reference:
FAQ: What characters should not be used in ArcGIS for field names and table names?http://support.esri.com/technical-article/000005588
Defining fields in tableshttp://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/design-defining-fields-in-tables.htm#GUID-80F2C74F-E7D4-47B6-8EBD-0D2E60DEB642
Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
