programplug Logo



SQL Table

SQL;



SQL Basic

» SQL Introduction

» What is SQL?

» What is RDBMS?

» Syntax In SQL

» Data Type In SQL

» Operators In SQL

» Truncate

SQL Table

» Table

» Table Variable

» Create Table

» Copy Table

» Alter Table

» Drop Table

SQL Commands

» Commands In SQL

» Create Statement

» Select Statement

» Delete Statement

» Drop Database

SQL Clause

» WHERE Clause

» AND Clause

» OR Clause

» WITH Clause

SQL Keys

» Primary Key

» Foreign Key

» Unique Key

»Null Value

» Not Null Value

SQL Joins

» Joins

» Inner

» Full

» Left

» Right

SQL Order

» Order By

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.