*-- Copy the structure to a temporary table USE data\sfacct COPY STRUCTURE EXTENDED TO tmpStruct *-- Add a new record to the table for your new field/column USE tmpStruct INSERT INTO tmpStruct (field_name, field_type, field_len, field_dec) ; VALUES ('NewField', 'C', 30, 0) *-- Create the new table CREATE NewTable FROM tmpStructCathy