1 files changed, 2 insertions, 1 deletions
diff --git a/src/shell.c.in b/src/shell.c.in
index da3b9f870..02850691d 100644
--- a/src/shell.c.in
+++ b/src/shell.c.in
@@ -8375,7 +8375,8 @@ static int do_meta_command(char *zLine, ShellState *p){
       zSql = sqlite3_mprintf(
         "SELECT sql FROM sqlite_schema AS o "
         "WHERE (%s) AND sql NOT NULL"
-        "  AND type IN ('index','trigger','view')",
+        "  AND type IN ('index','trigger','view') "
+        "ORDER BY type COLLATE NOCASE DESC",
         zLike
       );
       run_table_dump_query(p, zSql);