programplug Logo



SQL Table

SQL Table


A table is collection of related data in a organized terms of rows and coloumn. A table in SQL is the simplest form of data stroage and it is easy to represent the relations in SQL table.

EXAMPLE:
EMPLOYEE TABLE
E_ID E_NAME E_SALARY
1 TARUN 10000
2 JOHN 17000
3 MEHAKDEEP 15000
4 MENDA 10100
5 KARL 14500

In the above table EMPLOYEE is the table name and in this table E_ID,E_NAME,E_SALARY are the coloumn. The multiple data in coloumn is consits of rows e.g "1","TARUN", and "10000" are the data of one row.