SQL Table

Table is a collection of data organized in terms of rows and column.

Table is the simple form of data storage. A table is also considered as a convenient representation of relations.

Let's see an example of an employee table:

EMP_NAME	ADDRESS	SALARY
ALOK TIWARI	LUCKNOW	15000
RAMAN JAISWAL	ALLAHABAD	18000
SHREYA SRIVASTAVA	GHAZIABAD	20000

---

Topics of SQL TABLE Statement

SQL TABLE VariableWhat TABLE variable can do?

SQL CREATE TABLEHow to create a table using SQL query>

SQL DROP TABLEHow to drop a table?

SQL DELETE TABLEHow to delete all the records of a table?

SQL RENAME TABLE

How to rename a table?

SQL TRUNCATE TABLEHow to truncate a table?

SQL COPY TABLEHow to copy a table?

SQL TEMP TABLEWhat is temporary table? What are the advantage of temporary table?

SQL ALTER TABLEHow to add, modify, rename and drop column.