add field

08-22-2016 02:20 AM
New Contributor III

I have created a feature class using ArcGIS.
I want to add some columns using Oracle SQL alter table statement.
This works fine for me.
I want to know whether it is acceptable practice ?

0 Kudos
4 Replies
MVP Frequent Contributor

As long as your ALTER doesn't affect any of the ArcGIS fc required fields it will be fine

0 Kudos
by Anonymous User
Not applicable


Its works and acceptable in ArcGIS/GIS software.

But when you trying to create new use same process.


0 Kudos
MVP Esteemed Contributor

I get a sense you are new to ArcGIS, or at least new to working with Esri enterprise geodatabases.  There are lots of risks using SQL to directly manipulate database objects in enterprise geodatabases.  I don't mean edit the data in the objects, which can be risky in certain situations too, but changing the structure of the objects.  For example, is the data versioned?  If so, editing the base table using an SQL statement will cause a disconnect between the base table, add & delete tables, and any versioned views that have already been created.  If the data isn't versioned, it reduces the risk, but there are still changes that can be made using SQL that will break some part of the geodatabase.

SQL and enterprise geodatabases

0 Kudos
New Contributor III

Thanks to all

0 Kudos