nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can I add fields to feature class using SQL?

BenVan_Kesteren1

hey,

I know in the past I have risked corrupting my ESRI Enterprise Geodatabase as I have added/removed tables using SQL, this was a hard learned lesson as I didnt know there were references to these tables, in other tables (table registry etc).

When it comes to adding or dropping fields, can I do this using SQL rather than using the arcpy or geoprocessing tools? I am finding my map services are creating locks on my datasets, and the tools fail to run.

I know in the past if I use SQL this will bypass the locks and fields can be added/removed with no issues, but I am now fearful that as this is an ESRI database, could this have knock on effects that come back to bite me later.

Any thoughts with this?

Find more posts tagged with

Accepted answers

jskinner

I would not recommend editing the schema within SQL Server Management Studio.

All comments

jskinner

I would not recommend editing the schema within SQL Server Management Studio.

BenVan_Kesteren1

I will investigate this, see if it will help.

So does this mean I cannot edit the tables (adding & dropping new fields) safely using SQL?

jskinner

Hi Ben,

I would recommend disabling schema locking. This will allow you to make schema changes without having to stop the service:

Disable schema locking on a map service—ArcGIS Server Administration (Windows) | ArcGIS Enterprise

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.