If the data is in a Personal geodatabase (pGdB)(aka MS_Access), open the attribute table in Access, go to "Designer View" and rename fields, change attributes, reorder fields and SAVE ... all will be OK in ESRI IF you do NOT add/delete records. This is true for SQL_Express database (xGdB) using SQL Management Studio ... probably also true for data in MS_SQL enterprise geodatabases (eGdB) ... My paranoia has not let me do that ... I copy from the eGdB to xGdB, make my changes and then copy the data back... If the schema changes are SO EASY with MS_Access & MS_SQL_Management_Studio, why can't ESRI do it (connect to Microsoft code) to do this in Microsoft format databases? Mike Hickey Tulare County IT/GIS mhickey@co.tulare.ca.us >>> Brian Quinn <geonet@esri.com> 11/9/2018 11:34 AM >>> GeoNet ( https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_-3Fet-3Dwatches.email.idea-5Fcomment&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=iFrd8TcCToeUfkQQs547x3EKZWu0mBwiEhA6Q6odfPU&e=) ArcGIS should allow the ability to permanently reorder fields in a table new comment by Brian Quinn ( https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_people_bbq&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=XGkkBR03t4LKi0EpBIdzjAObFKXbeWtvOMTtQrbdl9o&e=) View all comments on this idea ( https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_ideas_1362-3FcommentID-3D67368-23comment-2D67368&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=6IpyGmCN7XvizLqhLodmiBTOiijT_PD2bqC6QHw3Jwk&e=) I stopped trying to do this. Now, I write a single spatial SQL query to PostGIS and visualise in QGIS. I get the attributes that I want in one step. I can export to share back to ArcGIS Pro users Brian B. Quinn brian.quinn@sfgov.org Reply to this email to respond to Brian Quinn's comment. Following ArcGIS should allow the ability to permanently reorder fields in a table ( https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_ideas_1362-3FcommentID-3D67368-26et-3Dwatches.email.idea-5Fcomment-23comment-2D67368&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=XVTqSKkl8h5TG2Zx7Sh5GQWTkT9i0oaV9rTclcw88mA&e=) in these streams: Inbox This email was sent by GeoNet because you are a registered user. You may unsubscribe ( https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_unsubscribe.jspa-3Femail-3Dmhickey-2540co.tulare.ca.us-26token-3Da093a907f4dfc58a9d87b5f592a8de49e7463eeef829ea2f5220ff061641b572&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=0MzqsUOCNcHgvP-N-sDK8Z3rRtdLvIG0-hyJ0yjVvIc&e=) instantly from GeoNet, or adjust email frequency in your email preferences ( https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_user-2Dpreferences-21input.jspa&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=sscQJ0vl6e43pL41cUIvXQhLFzoe35teXH_PU32BPnQ&e=)
... View more