SQLite Forum

Dot Command - Square Brackets
The [...] name quoting is a Sybase-ism.  It is not standard SQL.
SQLite does it for compatibility with (sybase-derived) MS SQL Server.
The standard way to escape identifiers is double-quotes:  "..."

The ".schema" command is part of the CLI, not the core SQLite database
engine.  The CLI does not implement the [...] Sybase-ism.