Registering a non-spatial view or table with Enterprise Geodatabase

[HaniDraidi]

How can I register a non-spatial view or table with Enterprise Geodatabase using Sde command line?

Any help is appreciated

Best,

Hani

[ChrisDonohue__GISP]

To help contributors answer this, what version of SDE are you using?  Also, is it tied to Oracle, SQL server, or another?  And what version?

Enterprise GIS

Chris Donohue, GISP

[RebeccaStrauch__GISP]

It might be worth mentioning that this is related to this other thread (slightly different question, but additional info is in that thread) Spatial view Problem   which mentions  "SQL Server 2014 in an enterprise geodatabase."

It's harder to find SDE command line help docs these days, but have you looked thru this help doc?

ArcGIS Server for the Microsoft .NET Framework 9.3 Help

[VinceAngelo · Accepted solution]

Why do you need the non-spatial view registered with ArcSDE? There aren't many use cases that require this.

Any table or view can be registered with ArcSDE with:

sdetable -o register -t tablename -C USER -c rowidcolumn -i sde:... -D ... -u ... -p ...

But if there isn't any pressing reason to do so, I would recommend against it.

- V

[HaniDraidi]

Once again, Thank you very much Vince!

It worked fine!