SQL Constraints

Google Advertisements

SQL Update Command Primary Key in SQL

SQL Constraints

Constraints is a mechanism which is used to stop or Restrict invalid data which is entered by the end user.

constraints

We can apply the constraints in two situations

  • During creation of table
  • After creation of table

We can apply the constraints in two level on the table.

  • Column level constraints
  • Table level constraints

Column level constraints

Applying the constraints after defined the column immediately than those constraints called as column level constraints.

Table level constraint

Applying the constraints after defined all the column of the table or end the table if apply the constraints than these constraints called as table level constraints.

Example

	
CREATE TABLE table_name
(
column_name1 data_type(size) constraint_name,
column_name2 data_type(size) constraint_name,
column_name3 data_type(size) constraint_name,
....
);

What is a KEY?

A KEY is a value used to identify a record in a table uniquely. A KEY could be a single column or combination of multiple columns

Note: Columns in a table that are NOT used to identify a record uniquely are called non-key columns.

Constraints in SQL

  • Unique key
  • Not NUll
  • Primary key
  • Check
  • Foreign key
  • Default

SQL Update Command Primary Key in SQL

Google Advertisements

We have more than 5 Groups which have 500000+ Members and some Pages have more than 100000+ members. If you want to post your article on our website/FB Group/FB Page please contact on hitesh.xc@gmail.com or 8076671483

Buy This Ad Space @$50 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 8076671483

Path variable is set for providing path for all Java tools like java, javac, javap, javah, jar, appletviewer which are used in java programming. All these tools are available in bin folders so we set path upto bin folders. Difference between path and classpath in Java

Classpath variable is set for providing a path for predefined Java classes which is used in our application. All classes are available in lib/rt.jar so we set classpath upto lib/rt.jar. Difference between path and classpath in Java

Cloud computing is the on demand availability of computer system resources, especially data storage and computing power, without direct active management by the user. Cloud Computing Tutorial

College Projects Related to Java, AWT, C Projects for College, C++ Projects for College, Android Projects. Download Java C C++ Projects

Download Projects

Adsense Advertisements


Buy This ads Space 8076671483

Buy This Ad Space @$120 per Month, Ad Size 300X600 Contact on: hitesh.xc@gmail.com or 8076671483 Try this Keyword C++ Programs