A new-table-Name represents a renamed table. You cannot qualify a new-table-Name with a schema-Name.
SQL92Identifier
-- FlightBooks is a new-table-Name that does not include a schema-Name RENAME TABLE FLIGHTAVAILABILITY TO FLIGHTAVAILABLE