diff options
Diffstat (limited to 'litecli/sqlexecute.py')
-rw-r--r-- | litecli/sqlexecute.py | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/litecli/sqlexecute.py b/litecli/sqlexecute.py index 2b8fce3..3f78d49 100644 --- a/litecli/sqlexecute.py +++ b/litecli/sqlexecute.py @@ -38,6 +38,13 @@ class SQLExecute(object): ORDER BY tableName, columnName """ + indexes_query = """ + SELECT name + FROM sqlite_master + WHERE type = 'index' AND name NOT LIKE 'sqlite_%' + ORDER BY 1 + """ + functions_query = '''SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE="FUNCTION" AND ROUTINE_SCHEMA = "%s"''' |