Gibson Digital Enterprises

This document contains commands that run in the Forest environment and their syntax. All commands can be typed in all upper case or all lower case. All Database names, table names, and column names are case sensitive. Data being matched or inserted should be contained in single quotes ('), especially if spaces are being used within.


 ::ALTER::

  ALTER DATABASE|TABLE|USER database|table|user RENAME|SET [new_name|PRIMARY|PASSWORD] [column|password]

  Example1:

  alter table TestTable set primary TestColumn


  Example2:

  alter database TestDatabase rename TestDatabase2


  Example3:

  alter table TestTable rename TestTable2

  Example4:

  alter user User set password NewPassword


 ::CONNECT::

  Description: Connect to a database.

  CONNECT database [VERBOSE]

  Example:

  connect TestDatabase

 ::COUNT::

  COUNT value IN table

 ::CREATE::

  CREATE DATABASE|TABLE|USER database|table|user [datatype1|password] [column1] [datatype2] [column2] ....

  Example 1:

  create database TestDatabase

  Example 2:

  create table TestTable int SpecialID varchar LastName

  Example 3:

  create user NewUser Password

 ::DELETE::

  DELETE FROM table WHERE column IS value

 ::DESCRIBE::

  DESCRIBE table [VERBOSE]

  Example:

  describe TestTable

 ::DROP::

  DROP TABLE table [VERBOSE]

 ::EXIT::

  EXIT

 ::INSERT::

  INSERT INTO table VALUES 'value1' 'value2' ....

 ::PROMPT::

  PROMPT string

 ::QUIT::
  
  QUIT


 ::REVOKE::

  REVOKE ALL|ALTER|CREATE|DELETE|DROP|INSERT|REVOKE|SELECT|SHOW FROM user


 ::SELECT::

  SELECT ALL|COUNT|column FROM table [WHERE] [column] [CONTAINS|IS] ['value'] [VERBOSE]

  Example 1:

  select all from TestTable

  Example 2:

  select all from TestTable where LastName is 'Williams'

  Example 3:

  select SpecialID from TestTable where LastName is 'Williams'

  Example 4:

  select count from TestTable


 ::SHOW::

  SHOW ACTIVE|ALL|LICENSE|DATABASES|TABLES [VERBOSE]

 ::USE::

  USE database [VERBOSE]