How to create a database
Graphically
Right click on databases then click on NEW DATABASE then type databasename in databasename option
Query way
| create database databasename
|
How to alter database
Graphically
Right click on database do you want to rename then click on rename and then modify the database name
Query way
| alter database oldDatabaseName modifyname=newdatabasename
|
How to drop a database
| drop database databasename
|
How to connect database
How to create a table
Graphically
Right click on tables then click on NEW then Table then add column names and datatypes and right click on query window then sava table with name.
Query way
| create table tablename(column1 datatype,column2 datatype)
|