how to add database in sql server code example
Example 1: CREATE DATABASE DatabaseName;
SHOW DATABASES;
DROP DATABASE testDB;
USE DatabaseName;
SQL> CREATE TABLE CUSTOMERS(
ID INT NOT NULL,
NAME VARCHAR (20) NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR (25) ,
SALARY DECIMAL (18, 2),
PRIMARY KEY (ID)
);
DESC CUSTOMERS;
Example 2: create a db
#TO Create a DB :
CREATE DATABASE <DB_NAME>;
#example : CREATE DATABASE MyDataBase ;
#To Create a Table :
CREATE TABLE <TB_NAME>(
<Elem 0> <Type_of_Elem created> <ADD_PROPRETIES>, #Don't forget the comma
...
...
...
<Elem n> <Type_of_Elem created> #last elems don't need a comma
);
/*example :
CREATE TABLE city (
id int NOT NULL IDENTITY(1, 1),
city_name char(128) NOT NULL,
lat decimal(9,6) NOT NULL,
long decimal(9,6) NOT NULL,
country_id int NOT NULL,
CONSTRAINT city_pk PRIMARY KEY (id)
);
*/