coderz.py

Keep Coding Keep Cheering!

SQL: Truncate, Drop, Rename Query

The various DDL commands that are used to redefine the tables will be covered in this tutorial. Truncate Query: TRUNCATE statement is a Data Definition Language (DDL) operation that is used to mark the extent of a table for deallocation (empty for reuse). This method instantly deletes all of the data from a table while […]

March 15, 2023 | DBMS | No comments

SQL: ALTER command

The ALTER command is a DDL command that can be used to change the structure of existing tables in the database by adding, modifying, renaming, or removing columns and constraints. Using the ALTER command, you can add columns, rename columns, delete columns, or change the data type of columns. ALTER Command: Syntax Adding a Column: […]

March 14, 2023 | DBMS | No comments

Advertisement