Re: TRUNCATE TABLE

Ben Draper wrote: > > And say another table has foreign key constraints (not necessarily any rows) > against this table, what then? > Do you have to manually recreate these tables as well? > Not the tables, but definitely the constraints. I'd recommend Art Kagel's 'myschema' for this task, as it has the capability to determine any foreign key constraints on a table and include them in the table object SQL as well. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */