I was planning to run "sdetable register" command to register a particular field as OID for an non-spatial table already created in a SDE database. I am with SQL Server 2008 R2.
I tried to run the command
USE [{database}]
GO
sdetable -o register -t {table} -c {column} -C {database} -u {user} -p {password}
from on a query window in SQL Server Management Studio.
But it logged "Incorrect syntax near 'o'." error.
Is there anything wrong with what I was doing?
asked Apr 12, 2012 at 0:54
1 Answer 1
That isn't a SQL Command, but a DOS/Command Line function you need to use to register the table. You need to launch a command prompt and use your command from after your 'GO' statement to register your table.
answered Apr 12, 2012 at 0:58
-
But just for curiosity: is there any sql command that can be run within SQL Server to register a table?alextc– alextc2012年04月12日 01:37:38 +00:00Commented Apr 12, 2012 at 1:37
-
Im not aware of any single command from the TSQL syntax that could do this. As this process talks to several different tables and StoredProc; I doubt if you would want to attempt it manually.D.E.Wright– D.E.Wright2012年04月12日 15:25:07 +00:00Commented Apr 12, 2012 at 15:25
Explore related questions
See similar questions with these tags.
lang-sql