Import data - order list

NNicole · #1 (**permalink**) 01-10-05, 09:16

Hello all!

I'm trying to find out how to get an ordered list of all tables to import data in db according to foreign keys that exist. I don't have idea how to do that...

Thank you in advance,
NNicole

n_i · #2 (**permalink**) 01-10-05, 10:55

Normally you would drop the constraints, load data, and then re-create the constraints.

ARWinner · #3 (**permalink**) 01-11-05, 08:47

NNicole
If you do not want to drop the FKs, I posted on this forum a query to get what you want. You can locate it here also:

http://www.db2click.com/scribble.htm

Andy

NNicole · #4 (**permalink**) 01-11-05, 08:48

I know that way, but I'd like to exclude data that doesn't "fit" before I import them. Not exactly exclude rows, just to see where (on what tables) db rejects to import because of ref. integrity...

Internet Services

Web Development

Digital Marketing

Consumer Tech