SQL Create statement is used to create a database .
create database databaseName ;
Now if you wanna to add tables in that database then first you have to use that databse using USE DATABASE_NAME and then use create table statement .
Now If you want to Drop Database then using SQL Drop statement you can easily delete or remove indexes from the table in the database .
Drop Database DatabaseName ;
Note -> If you delete or drop the database using this statement then all the tables and views will also be deleted . SO be careful while using this statement .
How to Rename the Database ?
Once creating database and then you want to Rename the database name then by using SQL Rename statement you can easily changed the name of the existing database .
Rename Database **oldDatabaseName** To **newDatabase-name** ;
How to Select a current Database ?
Using SQL select statement you can select any database and can perform the task whatever you want like retreive information , update some information into the database etc . Or suppose you want to retrieve the information from specified column from a table then you can also do with this statement .
Select col-name From table-name [ where clause ] or [ Group by clause ] or [ having clause ] or [ order by clause ] ; // you can use all these clause with select statement to perform some specific task