add table (gcPLANHOME+lcCHTABLE) use (gcPLANHOME+lcCHTABLE) in 0 excl select (lcCHTABLE) *remove plan table fields from new ch table alter table (gcPLANHOME+lcCHTABLE) drop column inid alter table (gcPLANHOME+lcCHTABLE) drop column indatetime alter table (gcPLANHOME+lcCHTABLE) drop column chid *keep chdatetime ALTER TABLE (gcPLANHOME+lcCHTABLE) ADD COLUMN logid I ALTER TABLE (gcPLANHOME+lcCHTABLE) ADD COLUMN uwapprvl C(2) alter table (gcPLANHOME+lcCHTABLE) add foreign key planid tag planid && gets "syntax error" alter table (gcPLANHOME+lcCHTABLE) add foreign key logid tag logid alter table (gcPLANHOME+lcCHTABLE) add foreign key chdatetime tag chdatetimeWhere is code wrong? Thanks.