How to perform database and table operations in SQLYog ?

Database operations

DB > Create database : Created DB will be displayed immediately in the Object browser

DB > Create table : Created table will be displayed immediately in the Object browser

DB > Copy database to different hosts/DB : Copy entire DB or selected tables of DB to other host/machine or DB

Some menu automatically writes basic query in the SQL Editor, which can be completed manually, like:

DB > Create view

DB > Create stored procedure

DB > Create function

DB > Export DB as SQL statements: exports selected DB and corresponding tables to a .sql file.

DB > Import batch file : imports multiple SQL queries from .sql file.

DB > Drop DB : Deletes the selected DB

DB > Truncate DB : Truncates data of all the table of selected DB

DB > Empty DB : Deletes all the table of selected DB

Table operations

For write basic SQL statements use options :

Table > Paste SQL statements > INSERT INTO

Table > Paste SQL statements > SELECT

Table > Create trigger

Table > Copy table to different hosts/DB : copy selected tables of DB to other host/machine or DB

Table > Create table : Created table will be displayed immidiately in the Object browser

Table > Alter table : Modifies selected table structure.

Table > Manage Indexes : Creates or edit indexes for selected table.

Table > Relationships/ foreign keys : Creates or edit foreign keys for selected table.

Table > Export/Import > Export table as SQL statements : Export data of selected tables to .sql file.

Table > Export/Import > Export table data : Export data of table with corresponding selected columns to CSV, XML or HTML file.

Table > Export/Import > Import data from CSV

Table > Duplicate Table structure / data : Copy table structure along with data to another table.

Table > Rename Table : Changes table name

Table > Empty Table : Deletes all data of table

Table > Drop Table : Delete the table itself

Table > Reorder columns : Changes the order of columns of table

Table > Change table type : to BDB, Gemini, HEAP, ISAM, MERGE, InnoDB or MyISAM.

Object operations

In these operations, one can drop column or create / alter / drop / rename the Views / Trigger / Procedure / Function.