.schema: line breaks and missing index information
balta2ar opened this issue · 0 comments
balta2ar commented
sqlite:
→ sqlite3 imdb-cmudb2022.db
SQLite version 3.37.2 2022-01-06 13:25:41
Enter ".help" for usage hints.
sqlite> .schema people
CREATE TABLE people (
person_id VARCHAR PRIMARY KEY,
name VARCHAR,
born INTEGER,
died INTEGER
);
CREATE INDEX ix_people_name ON people (name);
sqlite>
litecli:
→ litecli imdb-cmudb2022.db
Version: 1.9.0
Mail: https://groups.google.com/forum/#!forum/litecli-users
GitHub: https://github.com/dbcli/litecli
imdb-cmudb2022.db> .schema people
+--------------------------------------------------------------------------------------------------------------+
| sql |
+--------------------------------------------------------------------------------------------------------------+
| CREATE TABLE people (\n person_id VARCHAR PRIMARY KEY,\n name VARCHAR,\n born INTEGER,\n died INTEGER\n) |
+--------------------------------------------------------------------------------------------------------------+
Time: 0.012s
imdb-cmudb2022.db>