topic Re: How to create an SDE View in 10.3 in Developers Questions

How to create an SDE View in 10.3

JoseSanchez — Tue, 19 Jan 2016 23:51:02 GMT

Hello everyone,

How can I create an sde view or modify an existing sde view created in 10.0 witn 10.3?

Thanks

Re: How to create an SDE View in 10.3

AsrujitSengupta — Wed, 20 Jan 2016 01:35:17 GMT

The answer is quite the same. Only that SDE Command line tools have been deprecated at 10.3.x, however it can still be used for now with an SDE 10.3.x geodatabase.

44300 - Can ArcSDE command line tools be used against 10.3 and newer geodatabases?

Re: How to create an SDE View in 10.3

VinceAngelo — Wed, 20 Jan 2016 04:01:34 GMT

Keep in mind that there really hasn't been anything called an "SDE View" for a long time. The term of art is "spatial view" or just "database view" (geometry columns being a normal part of modern databases).

The only time sdetable -o create_view should be used is with SDEBINARY storage geometry layers (which are rapidly becoming rare). For all other use cases, the database or geodatabase view construction tools are the appropriate tools. After view construction and validation, you can use sdelayer -o register to eliminate the Query Layer requirement of selecting an ID column (views must always be registered with a USER-set rowid column).

If you need to replace an existing view which has been registered with ArcSDE, you should use ArcCatalog or sdetable -o delete to drop the previous view, then use database tools to recreate the view, then use sdelayer -o register to re-register with ArcSDE.

- V