*-- 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 tmpStruct