SQLiteDBMS-beta

If you want more documents. Visit http://sqlitedbms.sourceforge.net/

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 }


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
    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 }
