|
Create/Modify/Drop/Rename a Table
|
Previous Top Next |
As easy as pie! Simply select the Tables folder just below your Databases folder, right click and type in your new table name in the Add box and press Enter. You will be prompted to confirm. MyCon will create a new table with the name you specified and the table will have a default ID autoinc column set as the primary key of your table. You can change the column and primary key using the steps in the next section.
Select your table in the Folders pane, right click it and click on Properties. This will open the Table Properties window, where you can add, modify and delete columns. Also you can add and delete existing table indexes, setup the default table data view grid options and see general MySQL information of the table in this window.