SCHEMA Alias Added for DATABASE to Enhance MySQL Compatibility

Why it matters

The addition of the SCHEMA keyword as a synonym for DATABASE solves compatibility issues for users migrating from MySQL or working in mixed environments. It simplifies query adjustments and improves interoperability by allowing queries using standard MySQL terminology.

How to use it

Users can now use SCHEMA interchangeably with DATABASE in their SQL queries, for example:

SHOW TABLES FROM <schema_name>;

This requires no additional configuration—simply replace or use SCHEMA where DATABASE was previously used.