AnsweredAssumed Answered

Changing table structures directly in database (Oracle)

Question asked by _robert_ on Aug 13, 2019
Latest reply on Aug 14, 2019 by George_Thompson-esristaff

Hi there,


I need to add columns to database tables. I dont want to use any GUI but do that through SQL so that any changes I have done can be easily reproduced in a different environment (first test, than production).

I'm not yet very familiar with SDE - therefore my questions:


1) can you safely change table structure (adding / removing and changing datatype/datatype settings) in SQL or do you need to do these modifications with an ESRI tool (basically - does ArcCatalog or other tools do something in the background when you modify tables through them?)


2) can you add new tables (tables with and without spatial data)?

I assume for tables with spatial data you need to do some registration in the SDE schema. It seems you need to use ArcCatalog for that - as I do not need to add many tables I'm happy with that step being performed in Catalog. But I would like to create the table itself through SQL.


Tables are versioned. ArcMap 10.5 and Oracle 11,


Many thanks for any tipps,