v.22.9Improvement

Allow CONSTRAINTs for ODBC and JDBC tables

Allow CONSTRAINTs for ODBC and JDBC tables. #34551 (Alexey Milovidov).
Allow defining CONSTRAINTs on ODBC and JDBC tables in ClickHouse.

Why it matters

This feature enables users to add CONSTRAINTs when working with ODBC and JDBC table engines, improving data integrity and validation by enforcing rules directly on external tables accessed via these connectors.

How to use it

Users can now include CONSTRAINT definitions when creating or altering ODBC and JDBC tables, similar to other table engines. Define constraints within the CREATE TABLE or ALTER TABLE statements as usual.