topic Re: Can I add fields to feature class using SQL? in Data Management Questions

Can I add fields to feature class using SQL?

BenVan_Kesteren1 — Wed, 16 Oct 2019 06:10:04 GMT

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?

Re: Can I add fields to feature class using SQL?

JakeSkinner — Wed, 16 Oct 2019 12:20:17 GMT

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

Re: Can I add fields to feature class using SQL?

BenVan_Kesteren1 — Thu, 17 Oct 2019 01:04:25 GMT

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?

Re: Can I add fields to feature class using SQL?

JakeSkinner — Thu, 17 Oct 2019 19:22:33 GMT

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