Saturday, 11 August 2018

arcgis 10.0 - How to run "sdetable register" command in SQL Server?


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?



Answer



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.


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...