Online Documentation for SQL Manager for MySQL
New Table
Relational databases store all their data in Tables. A table is a data structure consisting of an unordered set of horizontal rows, each containing the same number of vertical columns. The intersection of an individual row and column is a field that contains a specific piece of information. Much of the power of relational databases comes from defining the relations among the tables.
To create a new table:
- select the Database | New Object... main menu item;
- select Table in the Create New Object dialog;
- define table properties using the appropriate tabs of Table Editor.
Hint: To create a new table, you can also right-click the Tables node or any object within this node in the DB Explorer tree and select the New Table item from the context menu.
To rename a table:
- select the Rename Table <table_name> item from the table context menu
or
- simply press Ctrl+R
To edit table:
- double-click the table in DBExplorer to open it in the Table Editor;
or
- right-click the table in DBExplorer and select the Edit Table <table_name> item from the context menu.
To drop table:
- right-click the table in the DBExplorer and select the Drop Table <table_name> item;
or
- select the table and press Ctrl+Del.
There is a specific wizard for duplicating objects. To copy table use the Duplicate Table <table_name> item from the table context menu. Duplicate object wizard in this case will be opened at the Selecting destination database, as the previous ones provide selecting of source database and object to copy.
- Using Navigation bar and Toolbar
- Setting table properties
- Specifying table fields
- Viewing DDL definition