create a db

1CREATE DATABASE databasename;

1#TO Create a DB :
2CREATE DATABASE <DB_NAME>;
3#example : CREATE DATABASE MyDataBase ;
4#To Create a Table :
5CREATE TABLE <TB_NAME>(
6    <Elem 0> <Type_of_Elem created> <ADD_PROPRETIES>, #Don't forget the comma
7  	...
8  	...
9  	...
10    <Elem n> <Type_of_Elem created> #last elems don't need a comma 
11);
12/*example :
13CREATE TABLE city (
14    id int  NOT NULL IDENTITY(1, 1),
15    city_name char(128)  NOT NULL,
16    lat decimal(9,6)  NOT NULL,
17    long decimal(9,6)  NOT NULL,
18    country_id int  NOT NULL,
19    CONSTRAINT city_pk PRIMARY KEY  (id)
20);
21*/
22