Table in wrong subdirectory (OpenInsight Specific)
At 26 OCT 2000 11:28:24AM John wrote:
I inadvertently created a table in Datavol. Can I move this table from Datavol or do I need to recreate it.
Thanks,
John
At 26 OCT 2000 11:59AM Oystein Reigem wrote:
john,
in system editor do run Copy_Table etc with the appropriate parameters to copy the table to its new location, under a new name. then run Delete_Table etc to delete the original.
if you need to keep the old name of the table just do another Copy_Table and Delete_Table.
- oystein -
At 27 OCT 2000 03:46AM Simon Wilmot wrote:
or even better, after original copy and delete, just do a Rename_Table .
Simon
At 27 OCT 2000 05:14AM Oystein Reigem wrote:
Simon,
Now don't be so smug. Rename_Table is not docced. What are the parameters? Just old and new table name?
- Oystein -
At 27 OCT 2000 10:39AM Simon Wilmot wrote:
Sorry Oystein,
TableName, @DBID, NewTableName, Lockflag
Your humble servant
Simon
At 27 OCT 2000 12:45PM Oystein Reigem wrote:
Simon,
Great! Thanks!
- Oystein -