Connecting to the Database
Connect to the database. For details on database connection, refer to "8.3.1 Connecting to the Database".
Generating SQL Statements
Generate the SQL statements for creating the table. Select [Tables] in the [Data Source Explorer] view, then select [New Table] from the context menu. Refer below for the contents to specify in the dialog box:
Options
The SQL (DDL) statement corresponding to the selected option is generated.
Columns
Set the table name. Use the [Add Column] button to add a column, and then set the column name and data type.
Primary key
Select the primary key from within the column. Alternatively, set a name as the primary key.
Executing SQL Files
SQL statements are generated to the SQL File editor, and executed from the SQL File editor. For details on executing an SQL file, refer to "8.3.3 Executing SQL Statements".
When SQL is executed, the results are displayed in the [SQL Results] view. Refresh the [Data Source Explorer] view to check the created table.
