add field

[jayasudha]

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 ?

[NeilAyres]

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

[Anonymous User]

Hello,

Its works and acceptable in ArcGIS/GIS software.

But when you trying to create new use same process.

Thanks.

[JoshuaBixby]

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

[jayasudha]

Thanks to all