Select to view content in your preferred language

Registering a non-spatial view or table with Enterprise Geodatabase

3364
4
Jump to solution
01-24-2016 04:49 AM
HaniDraidi
Occasional Contributor II

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

Any help is appreciated

Best,

Hani

0 Kudos
1 Solution

Accepted Solutions
VinceAngelo
Esri Esteemed Contributor

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

View solution in original post

4 Replies
ChrisDonohue__GISP
MVP Alum

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

0 Kudos
RebeccaStrauch__GISP
MVP Emeritus

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
Esri Esteemed Contributor

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
Occasional Contributor II

Once again, Thank you very much Vince!

It worked fine!

0 Kudos