DataBase Constraint

 l DataBase Constraint:-

I. Data base constraint are the rules apply for the column in the database.

l Types od database constraint:-

1. Primary key constraint

2. Unique key constraint

3. Forigen key constraint

4. Not null constraint

5. Defult constraint

6. Check constraint :-

Syntax :- create table tablename(columnname datatype , CONSTRAINT name CHECK (CONDITION) );

Ex:-CREATE TABLE QDB(ID INT , AGE INT  CONSTRAINT  RST  CHECK (Age>20));

 

l How to apply constraint in existing table?

Ø Syntax:- ALTER TABLE TABLENAME ADD CONSTRAINT CONSTRAINTNAME CHECK (COND);

EX:-CREATE TABLE RK (ID INT , AGE INT );

ALTER TABLE RK ADD CONSTRAINT MY CHECK(AGE>20);

INSERT INTO RK VALUES (2,265);

l HOW TO REMOVE CONSTRAINT?

Ø SYNTAX:- ALTER TABLE TABLENAMR DROP CONSTRAINT

CONSTRAINTNAME ;

Ex:- ALTER TABLE RK DROP CONSTRAINT MY ;

 

INSERT INTO  rk VALUES(200,8);

 

 

 

 

l Default constraint:-default constraint assigned a default value to a column.

l Default constraint is uses defult keywords.

l Ex:-CREATE TABLE DEFDB(ID INT ,CITY VARCHAR(50) DEFAULT 'NAGPUR'); 

l insert into defdb values (101,‘pune’);

l   Task 3 create default constraint using alter command

Comments

Post a Comment

Popular posts from this blog

l 3-tier architecture (TIER)

DAY - 28-06-2003   l  3-tier architecture (TIER) 1.  3tier architecture provides three specific layer A.  BussinessObject layer B.  BussinessLogic layer C.  DataAcess layer   A.  BussinessObject layer :- It only created data member as per database column.   B.  BussinessLogic Layer  :- This layer only communicated with aspx page.   C.  DataAcess layer  :- In this layer we work on database .   l  How to create 3 tier architecture? Step 1 :- create layer GO TO SOLUTION EXPLOSER -> RIGHT CLICK ON SOLUTION-------->CLICK ON NEW PROJECT ->SELECT CLASS LIBRARY (.NET FRAMEWORK)C# -> NAME OF LIBRARY. Step 2 :- create a class in each layer 1.  BussinessLogic - classname=userBL. 2.  BussinessObject - classname=userBO. 3.  DataAccess-classname=userDA   How to create a class :- Rightclick on the layer -> add class Step 3 - change all class to public which we made. All class is used for ...
Read more

New html

 padding: 10px;             margin-top: 15px;             background: #28a745;             border: none;             color: white;             font-size: 16px;             border-radius: 4px;             cursor: pointer;         }         .btn:hover {             background: #218838;         }         .message {             margin-top: 10px;             text-align: center;             font-weight: bold;         }     </style> </head> <body>     <form id="form1" runat="server">         <div clas...
Read more

Bound Control (Data control)

  ·  DATA CONTROL :- DATA CONTROL IS USED FOR REPORTING CONCEPT.   ·  PROPERTY OF DATA CONTROL :- 1)  DATA SOURCE – DR 2)  DATA BIND – ()   ·  PROPERTY WITH NAME IS ERROR WHICH MEANS COLUMN NAME DOES NOT MATCH WITH GRID VIEW COLUMN.     THERE ARE FOLLWING DATA CONTROL 1)  GRID VIEW  :- A)  DISPLAY DATA IN TABULAR FORMAT B)  GRID VIEW INDEX STARTING FROM 0----N . C)  GRID VIEW IMPLEMENTATION a.  BASIC BINDING – STEP = SEARCH GRID VIEW à   CLICK ARROW à  EDIT COLUMN à  SELECT BOUND FIELD à  ADD   PROPERTY OF BOUND FIELD 1)  HEADERTEXT 2)  DATAFIELD – NAME OF COLUMN   HOW TO REMOVE EXTRA COLUMN   AUTO GENERATE CHECKBOX UNSELECT.   Ø  CODE OF BASIC BINDING Ø              //OPEN CONNECTION Ø               string  PATH = @...
Read more