v.21.11Improvements

User Can Create Dictionaries and Databases with Comments

User can now create dictionaries with comments: CREATE DICTIONARY ... COMMENT 'vaue' ... #29899 (Vasily Nemkov). Users now can set comments to database in CREATE DATABASE statement ... #29429 (Vasily Nemkov).
Support for adding comments to dictionaries and databases. Users can now include descriptive comments in the CREATE DICTIONARY and CREATE DATABASE SQL statements using the COMMENT clause.

Why it matters

This feature allows users to document their dictionaries and databases directly within the metadata. Adding comments improves maintainability and clarity by providing context about the purpose or contents of these objects, making it easier for teams to understand their structure and usage.

How to use it

To add a comment when creating a dictionary, include the COMMENT 'your comment' clause in the CREATE DICTIONARY statement. Similarly, to comment a database, add COMMENT 'your comment' in the CREATE DATABASE statement. For example:

CREATE DICTIONARY dict_name ... COMMENT 'This dictionary stores user data';


CREATE DATABASE db_name COMMENT 'This database contains analytics data';