summaryrefslogtreecommitdiffstats
path: root/litecli/packages/special/dbcommands.py
diff options
context:
space:
mode:
Diffstat (limited to 'litecli/packages/special/dbcommands.py')
-rw-r--r--litecli/packages/special/dbcommands.py5
1 files changed, 3 insertions, 2 deletions
diff --git a/litecli/packages/special/dbcommands.py b/litecli/packages/special/dbcommands.py
index 203e1a8..dec3507 100644
--- a/litecli/packages/special/dbcommands.py
+++ b/litecli/packages/special/dbcommands.py
@@ -69,13 +69,14 @@ def show_schema(cur, arg=None, **_):
args = (arg,)
query = """
SELECT sql FROM sqlite_master
- WHERE name==?
+ WHERE name==? AND sql IS NOT NULL
ORDER BY tbl_name, type DESC, name
"""
else:
args = tuple()
query = """
SELECT sql FROM sqlite_master
+ WHERE sql IS NOT NULL
ORDER BY tbl_name, type DESC, name
"""
@@ -212,7 +213,7 @@ def load_extension(cur, arg, **_):
"Description of a table",
arg_type=PARSED_QUERY,
case_sensitive=True,
- aliases=("\\d", "describe", "desc"),
+ aliases=("\\d", "desc"),
)
def describe(cur, arg, **_):
if arg: