topic Add Columns to Table in use by Map Service in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/add-columns-to-table-in-use-by-map-service/m-p/694349#M26625 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P><BR />Is it a good practice to add columns to a table/feature-class from Database which is in access(read-only) by ArcGIS Server Map Services.</P><P></P><P>ArcMap 10.7</P><P>ArcGIS Enterprise 10.6</P><P>SQL Server DB 2016</P></BODY></HTML> Mon, 17 Aug 2020 18:33:38 GMT User35487 2020-08-17T18:33:38Z Add Columns to Table in use by Map Service https://community.esri.com/t5/arcgis-enterprise-questions/add-columns-to-table-in-use-by-map-service/m-p/694349#M26625 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P><BR />Is it a good practice to add columns to a table/feature-class from Database which is in access(read-only) by ArcGIS Server Map Services.</P><P></P><P>ArcMap 10.7</P><P>ArcGIS Enterprise 10.6</P><P>SQL Server DB 2016</P></BODY></HTML> Mon, 17 Aug 2020 18:33:38 GMT https://community.esri.com/t5/arcgis-enterprise-questions/add-columns-to-table-in-use-by-map-service/m-p/694349#M26625 User35487 2020-08-17T18:33:38Z Re: Add Columns to Table in use by Map Service https://community.esri.com/t5/arcgis-enterprise-questions/add-columns-to-table-in-use-by-map-service/m-p/694350#M26626 <HTML><HEAD></HEAD><BODY><P>I dont believe you can modify a feature class schema when there is a service running that is using that feature class.</P></BODY></HTML> Mon, 17 Aug 2020 23:37:10 GMT https://community.esri.com/t5/arcgis-enterprise-questions/add-columns-to-table-in-use-by-map-service/m-p/694350#M26626 MichaelVolz 2020-08-17T23:37:10Z Re: Add Columns to Table in use by Map Service https://community.esri.com/t5/arcgis-enterprise-questions/add-columns-to-table-in-use-by-map-service/m-p/694351#M26627 <HTML><HEAD></HEAD><BODY><P>Yes, through ArcGIS it is not possible. But it could be done through database tool, like SSMS in SQL Server.</P></BODY></HTML> Tue, 18 Aug 2020 12:19:27 GMT https://community.esri.com/t5/arcgis-enterprise-questions/add-columns-to-table-in-use-by-map-service/m-p/694351#M26627 User35487 2020-08-18T12:19:27Z