Add incrementing ID field into SQL view

[KateřinaUhlířová]

Hello,

I need to use sql view in service with feature acces on ArcGIS server but I can't publish the service because I don't have auto increment field in the view. Is there any option how to add the column with incrementing ID to the existing view? Tool Add incrementing ID field doesn't work.

Thanks for any answer

[George_Thompson]

Here is some documentation related to publishing views and editing them as feature services. It is not supported.......

As noted in the geodatabase requirements, layers based on views defined on geodatabase data are not supported in feature services. You can include views from databases in feature services; however, editing data accessed through a view that you include in your feature service is not supported. If you want data from a view included for reference, publish it in a different feature service or a map service.

Author feature services—Documentation | ArcGIS for Server

ArcGIS for Server​ Enterprise GIS​