# In get_foreign_keys / get_multi_foreign_keys — pass raw schema through
  def get_foreign_keys(self, connection, table_name, schema=None, **kw):
      schema = schema or self.default_schema_name
      if self._is_single_table_reflection(schema, **kw):
          return self._get_table_foreign_keys(connection, table_name, schema, **kw)
      full_schema_name = self._get_full_schema_name(connection, schema, **kw)
      # Pass both: full_schema_name for the SHOW SQL,
      # schema (raw) for same-schema FK detection
      return self._get_schema_foreign_keys(
          connection, full_schema_name, user_schema=schema, **kw
      ).get(table_name, [])

  @reflection.cache
  def _get_schema_foreign_keys(self, connection, schema, user_schema=None, **kw):
      current_database, current_schema = self._current_database_schema(connection, **kw)
      same_schemas = {self.default_schema_name, current_schema}

      # Add the user-specified schema (schema part only, not db prefix)
      # so same-schema FKs within a non-default schema get referred_schema=None
      if user_schema:
          parts = self.identifier_preparer._split_schema_by_dot(user_schema)
          schema_only = parts[-1]          # last part is always the schema
          if "." not in str(schema_only):  # guard: don't add composite strings
              same_schemas.add(self.normalize_name(str(schema_only)))

      result = connection.execute(
          text(f"SHOW /* sqlalchemy:_get_schema_foreign_keys */ IMPORTED KEYS IN SCHEMA {schema}")
      )
      return self._parse_fk_rows(result, same_schemas, current_database)

  def test_get_foreign_keys_non_current_schema_same_db(engine_testaccount, ...):
      """FKs within a non-current schema should have referred_schema=None."""
      # Create a schema that differs from current_schema
      # Create two tables with an FK between them in that schema
      # Reflect FKs, assert referred_schema is None