v.25.6New Feature

It's now possible to write USE DATABASE

Official CH changelog text
It's now possible to write USE DATABASE name instead of USE name. #81307 (Yarik Briukhovetskyi).
Added support for the USE DATABASE name syntax as an alternative to USE name.

Why it matters

This feature enhances SQL syntax clarity and readability by allowing users to explicitly specify that they are switching databases with the USE DATABASE command, reducing potential ambiguity.

How to use it

Users can change the current database context by executing the SQL command:

USE DATABASE <database_name>;

This functions identically to the previously supported USE <database_name> syntax.

Related resources

PreviousNext