Creating Constraints (Bangla)

K݇UªB›U IivK‡j †Uwej ˆZixi mgq A_ev ‡Uwej ‰Zixi c‡i I Kiv hvq| GLb Avgiv wKfv‡e †Uwej ˆZixi mgq cÖvBgvix Kx K݇UªB›U ˆZix Ki‡Z nq Zv †`L‡ev| Avgiv Student bv‡g GKwU ‡Uwej ˆZix Ki‡ev | D³ †Uwe‡ji SID wdì Gi Dci cÖvBgvix Kx K݇UªB›U Ges  SNAME wd‡ìi Dci bU bvj K݇UªB›U †Zix Kivi Rb¨ wKfv‡e SQL †KvW wjL‡Z nq Zv †`L‡ev |

Create table student (
SID varchar2(30) primary key,
SNAME varchar2(200) not null,
SADD varchar2(200),
SBDATE date ,
SPH varchar2(20),
SEMAIL varchar2(30));

A_ev,

Create table student (
SID varchar2(30),
SNAME varchar2(200) not null,
SADD varchar2(200),
SBDATE date ,
SPH varchar2(20),
SEMAIL varchar2(30),

Constraints pk_sid primary key (SID) );

ai“b, Acwb †Uwej ˆZix K‡i‡Qb cÖvBgvix Kx K݇UªB›U Qvov wbb¥wjwLZ fv‡e,

Create table student (
SID varchar2(30),
SNAME varchar2(200) not null,
SADD varchar2(200),
SBDATE date ,
SPH varchar2(20),
SEMAIL varchar2(30));

GLb Zv‡Z cÖvBgvix Kx K݇UªB›U mshy³ Ki‡Z PvB‡j wbb¥ wjwLZ fv‡e SQL ‡KvW wjL‡Z n‡e|

ALTER TABLE student

add CONSTRAINT sid_pk PRIMARY KEY (SID);