SQLiteDBMS Extended SQL
Extended SQL
SHOW DATABASE
SHOW DATABASE
SHOW USER ( >= 0.2.1)
SHOW USER
SHOW TABLE
SHOW TABLE [tablename]
SHOW INDEX
SHOW INDEX [tablename]
SHOW TRIGGER
SHOW TRIGGER [tablename]
SHOW STATUS
SHOW STATUS
SHOW VERSION
SHOW VERSION
DESC
DESC { tablename | viewname }
SQLiteDBMS Extended SQL for administrator(super user)
CREATE DATABASE
CREATE DATABASE dbname
DROP DATABASE
DROP DATABASE dbname
CREATE USER
CREATE USER id password [SUPERUSER]
DROP USER
DROP USER id
ALTER USER ( >= 0.2.3)
ALTER USER id SET { PASSWORD newpassword | [ NO ]SUPERUSER }
GRANT ( >= 0.2.1)
GRANT { ALL | SELECT | INSERT | UPDATE | DELETE | ALTER | TRIGGER | SHOW } ON { dbname.tablename | dbname.* | *.* | * } TO { username | PUBLIC }
GRANT CREATE ( >= 0.2.1)
GRANT CREATE { ALL | TABLE | VIEW | INDEX | TRIGGER } ON { dbname | * } TO { username | PUBLIC }
REVOKE ( >= 0.2.1)
REVOKE { ALL | SELECT | INSERT | UPDATE | DELETE | ALTER | TRIGGER | SHOW } ON { dbname.tablename | dbname.* | *.* | * } TO { username | PUBLIC }
REVOKE CREATE ( >= 0.2.1)
REVOKE CREATE { ALL | TABLE | VIEW | INDEX | TRIGGER } ON { dbname | * } TO { username | PUBLIC }