Creating a Database

Once you’ve installed SQream you can create a database.

To create a database:

  1. Write a CREATE DATABASE statement.

    The following is an example of creating a new database:

    master=> CREATE DATABASE test;
  2. Reconnect to the newly created database.

    1. Exit the client by typing \q and pressing Enter.

    2. From the Linux shell, restart the client with the new database name:

      $ sqream sql --port=5000 --username=rhendricks -d test
      Interactive client mode
      To quit, use ^D or \q.
      test=> _

    The name of the new database that you are connected to is displayed in the prompt.