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?

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.

  • But just for curiosity: is there any sql command that can be run within SQL Server to register a table?
    – alextc
    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
    Apr 12, 2012 at 15:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.