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:
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.
Filed UnderJava SQL SQL Table