Registering a non-spatial view or table with Enterprise Geodatabase

2570
4
Jump to solution
01-24-2016 04:49 AM
Highlighted
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
Highlighted
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
Highlighted
MVP Frequent Contributor

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
Highlighted
MVP Esteemed Contributor

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

Highlighted
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

Highlighted
Occasional Contributor II

Once again, Thank you very much Vince!

It worked fine!

0 Kudos