Posted on 2002-04-21
Can someone help me out with this. It's annoying me.
I need to copy data from one database to another. I've got a list of tables from my SQL server on one side (source) and a list tables on my AS/400 on the other side (target).
The problem is, the SQL server gives me the owner name - dbo.Tablename. The AS/400 doesn't have the prepended owner name. I need to know HOW do I list the tables without their owner shown? This also happens with Oracle. Currently, I've hardcoded it to delete the owner name, but this won't work on systems which have owner's called anything but dbo.
Any help would be appreciated!