java2db

SQL

Sql FOREIGN KEY constraint on table column

on May 26, 2014     Leave a Comment

FOREIGN KEY constraint  represent relationships between tables. A foreign key is a column whose values... 

Sql CHECK constraint on table column

on May 24, 2014     Leave a Comment

Business rule validations can be applied on a column using CHECK constraint. It  must be specified by... 

Sql NOT NULL constraint on table column

on May 24, 2014     Leave a Comment

The use of  NOT NULL constraint is to restrict null values.By default the column allows the null values.We... 

Sql UNIQUE constraint on table column

on May 24, 2014     Leave a Comment

If any column/columns  in the table define with UNIQUE constraint , the specified column does not allow... 

Sql PRIMARY KEY constraint on table column

on May 14, 2014     Leave a Comment

Primary key constraint  identifies uniquely each row in the table.When you specify a primary key constraint... 

Sql full outer join on tables with an example

on May 11, 2014     Leave a Comment

The  full outer join returns all rows from right and left table.Fill in NULLs for missing matches on... 

Sql right outer join on tables with an example

on May 11, 2014     Leave a Comment

The  right outer join returns all rows of the right table even though there are no matches with the... 

Sql left outer join on tables with an example

on May 10, 2014     Leave a Comment

Left outer join returns all the  rows from the left table even though there are no matches with the... 

Sql inner join on tables with an example

on May 10, 2014     Leave a Comment

The inner join returns exact match rows from the two tables based on the join-predicate. It will check... 

SELECT statement to get records from the table in sql

on April 30, 2014     Leave a Comment

SELECT statement is used  select the data of a specific column/columns or entire record/records from... 


^ <