SQL Table
SQL ALTER TABLE
The ALTER TABLE statement is used to add, modify or delete columns in an existing table. It is also used to rename a table. You…
SQL TEMP TABLE
The concept of temporary table is introduced by SQL server. It helps developers in many ways: Temporary tables can be created at run-time and can…
SQL COPY TABLE
If you want to copy a SQL table into another table in the same SQL server database, it is possible by using the select statement….
SQL TRUNCATE TABLE
A truncate SQL statement is used to remove all rows (complete data) from a table. It is similar to the DELETE statement with no WHERE…
SQL RENAME TABLE
SQL RENAME TABLE syntax is used to change the name of a table. Sometimes, we choose non-meaningful name for the table. So it is required…
SQL DELETE TABLE
The DELETE statement is used to delete rows from a table. If you want to remove a specific row from a table you should use…
SQL DROP TABLE
A SQL DROP TABLE statement is used to delete a table definition and all data from a table. This is very important to know that…
SQL CREATE TABLE
SQL CREATE TABLE statement is used to create table in a database. If you want to create a table, you should name the table and…
SQL TABLE Variable
The SQL Table variable is used to create, modify, rename, copy and delete tables. Table variable was introduced by Microsoft. It was introduced with SQL…
What is 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…
