How to Create Database | Table with Identity|Primary key in SQLSERVER?
how to Create Database | table with Identity|Primary key in SQLSERVER?
hi friends,
In previous sessions, we had seen how to install ssms 2008r2 and how to open and connect wit h ssms
and also saw how to connect databaseengine,reporting services,intigration services and analysis services..
I think u got about installation and connection of ssms 2008r2
now I am going to show you how to create database tables and other things..etc
so guys please watch this video with special care expecially beginers..
have seen how to created db(name:sample) then see how to create table in sample db..
when we wanted to enter any db ,command is
use database name
eg:use sample
here I created table with identity and primary key..
identity means it automatically genarates keys so I set identity to eid with increment 1
primary key means it does not takes nulls and duplicates.......
after click save...
next give name to table
click ok...
my table emp has been created..
next we can check table created or not...
my table created successfully to check wether check in db or using as below select command
select * from employ
thats it...
thank u...
PLEASE SUBSCRIBE ,SHARE AND LIKE MY CHANNEL
/ prasadamudalapalli