Category Archives: sql

SQL – DROP Table Table of content SQL provides command to DROP an existing table completely in a database. Once SQL DROP command is issued then there is no way back to recover the table including its data, so be careful before issuing this command in production system. The SQL DROP Table Statement The SQL […]

SQL – Temporary Tables Table of content What are Temporary Tables? Temporary tables are pretty much what their name describes: they are the tables which are created in a database to store temporary data. We can perform SQL operations similar to the operations on permanent tables like CREATE, UPDATE, DELETE, INSERT, JOIN, etc. But these […]

SQL – ALTER TABLE Table of content SQL − ALTER TABLE Statement The SQL ALTER TABLE command is a part of Data Definition Language (DDL) and modifies the structure of a table. The ALTER TABLE command can add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or […]