Creating a Table

Using InterBase IBConsole, we will create a very basic table with two columns.`

1. On the toolbar, click to open the Interactive SQL dialog.
2. In the text box enter:

CREATE TABLE tweets (pkcol int, tweet varchar (255)); 
INSERT INTO tweets VALUES ( '1', 'hello world');
SELECT * FROM tweets

3. Click to execute the command.

4. The table with the columns and data appear in the SQL dialog.

View and Backup the Database

1. Click the drop-down arrow in the SQL dialog to return to IBConsole.

2. To view the table properties double-click the table name in the right-hand panel.

   • To view the code, click the Metadata tab.
   • To view the data, click the Data tab.

3. To backup the database, select "twitter_cache"; select Database > Maintenance > Backup / Restore > Backup, and complete the required information in the Database Backup dialog.

Advance To:

• Modifying your Data