create command create is a DDL command used to create a table or a database. Creating a Database To create a database in RDBMS, create command is uses. Following is the Syntax, create database database-name; Example for Creating Database create database Test; The above command will create a database named Test. Creating a Table create …
alter command alter command is used for alteration of table structures. There are various uses of alter command, such as, to add a column to existing table to rename any existing column to change datatype of any column or to modify its size. alter is also used to drop a column. To Add Column to …
SQL queries to Truncate, Drop or Rename a Table truncate command truncate command removes all records from a table. But this command will not destroy the table’s structure. When we apply truncate command on a table its Primary key is initialized. Following is its Syntax, truncate table table-name Here is an Example explaining it. truncate …