"".crdb_internal.create_schema_statements only shows schemas from `defaultdb`

**Describe the problem**

Appending `"".` to `crdb_internal.create_schema_statements` should cause it to show schemas across all databases. I would expect it to return an additional row for the `public` schema in the `movr` database. Instead, it only returns `defaultdb.public` when executed from the `movr` database.

```SQL
demo@127.0.0.1:26257/movr> SELECT * FROM "".crdb_internal.create_schema_statements;
database_id | database_name | schema_name | descriptor_id | create_statement
--------------+---------------+-------------+---------------+-----------------------
100 | defaultdb | public | 101 | CREATE SCHEMA public
(1 row)

Time: 11ms total (execution 11ms / network 0ms)

demo@127.0.0.1:26257/movr> SELECT * FROM crdb_internal.create_schema_statements;
database_id | database_name | schema_name | descriptor_id | create_statement
--------------+---------------+-------------+---------------+-----------------------
104 | movr | public | 105 | CREATE SCHEMA public
(1 row)

Time: 4ms total (execution 4ms / network 1ms)
```

Additional schemas created within the `movr` database do not appear.
Additional schemas created within the `defaultdb` database do appear.

**To Reproduce**

1. Run `cockroach demo`
2. Execute `SELECT * FROM "".crdb_internal.create_schema_statements`
3. Observe the returned rows

**Environment:**
- CockroachDB version: v22.2.5, v23.2.0-alpha
- Server OS: MacOS
- Client app:`cockroach sql`

Jira issue: CRDB-31095