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.