A newTableName represents a renamed table (see RENAME TABLE statement). You cannot qualify a newTableName with a schemaName.
SQL92Identifier
-- FLIGHTAVAILABLE is a newTableName RENAME TABLE FLIGHTAVAILABILITY TO FLIGHTAVAILABLE