SQL PRIMARY KEY|PRIMARY KEY in SQL|Primary Key (PK) Constraint in SQL Server| DBMS| CTTUTORIAL

Published: 07 September 2020
on channel: CT TUTORIAL
22
0

PRIMARY KEY in SQL|Primary Key (PK) Constraint in SQL Server

#CTTUTORIAL #DBMS #PRIMARY_KEY
In this Video you will learn about Primary Key Constraint in SQL.

Code:

CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
PRIMARY KEY (ID)
);

CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
CONSTRAINT PK_Person PRIMARY KEY (ID,LastName)
);

ALTER TABLE Persons
ADD PRIMARY KEY (ID);

ALTER TABLE Persons
ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName);

ALTER TABLE Persons
DROP PRIMARY KEY;

Follow me on :
Subscribe to this Channel!
https://bit.ly/32hPbjd
https://tinyurl.com/CTTUTORIAL2020

PLAYLIST:
EXCEL BASIS to Advanced:   • Move Excel Range Data with out using Cut c...  

EXCEL VBA MACRO:https://tinyurl.com/ctexcelvbamacro

SQL:    • Introduction to Relational Database Manage...  

Facebook:  / arka09  
Email:ct.tutorial2020@gmail.com
Telegram Channel:t.me/ct_tutorial

sql server,sql,microsoft sql server,primary key,primary key constraint,database constraints,pk constraint


On this page of the site you can watch the video online SQL PRIMARY KEY|PRIMARY KEY in SQL|Primary Key (PK) Constraint in SQL Server| DBMS| CTTUTORIAL with a duration of hours minute second in good quality, which was uploaded by the user CT TUTORIAL 07 September 2020, share the link with friends and acquaintances, this video has already been watched 22 times on youtube and it was liked by 0 viewers. Enjoy your viewing!