General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Copy table which is part of a database
i have amongst others, a table abc in my database xyz. i wish to make a copy of the table abc by:-
set exclusive on
select * from abc into table qqq
but i get an error message "File qqq already exists as part of a database". table qqq does not exist in the first place.
i also tried:-
set data to xyz
remove table abc
before i execute the select * command but i have the same result.
how do i accomplish my mission? ta
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only