Database Object - Table

          What - Definition

ü  Table is foundation of any database.

ü  It is used to store /manipulate data.

ü  A database consists of one or more tables.

ü  Table name is unique in a database.

ü  A table is collection of Columns and Rows.

ü  It can have one or more columns and rows.

Column

ü  Each column name must be unique in a table.

ü  Column represents the characteristics of data stored in the table.

ü  Column has pre-defined data types. (For example- int, varchar).

ü  Column can have various attributes. (For example- Key, Index, Default values).

Row

ü  Row contains original data.

 Why – Use

ü  It is used to store /manipulate data in database.

How - Implementation

ü  Various operations on database table can be performed by using SQL Queries.

ü  Operations like retrieve, insert, update, delete etc. can be performed using SQL Queries.