Create Command in SQL server 2012

CREATE keyword is used to create database objects like databases,Tables,Stored Procedures,functions,views,indexes,triggers etc  

1.Syntax to create Database:  

1.  CREATE DATABASE <database_name> 

if we use this syntax we will automatically get primary and log files with default options

example:

create database srinivas                                                                      

               (or)

2. CREATE DATABASE <database_name>
   on
(
Name=Logical_name,
filename=path&fileName,
size=<size>,
maxsize=<size>,
FileGrowth=<size>)
log on
(
Name=Logical_name,
filename=path&fileName,
size=<size>,
maxsize=<size>,
FileGrowth=<size>
)

for the above syntax we can able to specify our own values and names to the primay and log files

example:
create database srinivas
   on
(
Name=srinivas,
filename='G:\srinivas.mdf',
size=5MB,
maxsize=15MB,
FileGrowth=1MB)
log on
(
Name=srinivas_log,
filename='G:\srinivas_log.ldf',
size=2MB,
maxsize=5MB,
FileGrowth=1MB
)

Note:

The above two examples will create a databse, whnever we create a database if we dont specify any options it will create two files named it as primary file and log file.

Primary  file will contain the objects that we create in our database,so this file contains all the tables,procedures,functions,views and all.

Log file contains all the commands that we executed over that database.

Size by using this attribute we will set the initial size of primary and log files.

MaxSize by using this attribute we will set the maximum size of primary and log files that they can store.

FileGrowth by using this attribute we will set the auto growth  size of primary and log files,once the primary and log files reaches to filled with data and unable to store next,the then it will update the size with this size automatically.

2.Syntax to Create a Table:

CREATE TABLE <TABLE_NAME>
(
COLUMN_NAME1 DATATYPE[SIZE],
COLUMN_NAME2 DATATYPE[SIZE],
COLUMN_NAME3 DATATYPE[SIZE],
.
.
)

Example

CREATE TABLE EMPLOYEE
(
EID INT,
ENAME VARCHAR(15),
SAL INT
)

NOTE:

Rules to be followed while we are giving names to columns and tables:

1.Table name and Column name should be one word,i.e the column name or table name con't contain any embedded space.

create table employee details
(
eid int,
ename varchar(15),
sal int
)

above one is invalid

create table employeedetails
(
eid int,
e name varchar(15),
sal int
)

above one is invalid
2.Names of columns or table can't start with a number

create table 2employeedetails
(
eid int,
ename varchar(15),
sal int
)

create table employeedetails
(
eid int,
2ename varchar(15),
sal int
)

Both of the above examples are invalid
3.The names of tables and columns should not start with special character

create table &employeedetails
(
eid int,
ename varchar(15),
sal int
)

create table _employeedetails
(
eid int,
ename varchar(15),
sal int
)

create table employeedetails
(
&eid int,
ename varchar(15),
sal int
)

All the above examples are invalid.

** underscore can be use in front of column name

we will see more examples of how to create procedures,views,indexes,functions in near future.

Thanks
GSV