-
SELECT INTO query
Hello,
I have a SELECT INTO query and want to know how it works since I got an error all of sudden saying "You can't delete a table 'ABC': It is participating in one or more relationships. You have to delete the relationship."
My query is like:
SELECT ABC.* INTO ABC IN another_database FROM ABC
Could someone explain the error?
Thanks,
-
Which rdbms? Maybe wrong syntax, try:
select * into table_name from abc
-
I am using Microsoft Access 2003. The syntax is ok. If I removed the relationship (it is a simple one) it works, but I am afraid that it might cause another problem due to lack of the relationship.
From the error message SELECT INTO query seems to delete the table and re-create it, then transfer data. Is it right?
And how to use SELECT INTO query without the mentioned error?
Thanks,
-
Don't know much about Access.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|