Creating a table

Using this option, you can create tables within an existing database.

To create a table, choose the "Create" option from the "Select" list. Select "Table" from the next list. Enter the name of table you want to create in the "Table Name" textbox.

In order to create a table, you need to define at least one column for your table. Enter the column name in the "Column Name" textbox. Choose the data type for the column from the drop-down menu. Assign the attributes for the selected data type by clicking the appropriate check boxes next to data type drop-down menu. You can enter the maximum length of data for the column in the "length" textbox. Enter the default value for the column in the "Default" textbox if necessary. Click the "Build SQL Query" button. After reviewing the SQL Query click the "Run SQL Query" button to complete the operation. The result of operation will appear at the bottom of the page.