Learn2Done

Modifications like adding, deleting in a existing table can be done using ALTER TABLE statement.  Various constraints can be added...

To delete a table from database, we use DROP TABLE statement  Syntax: DROP TABLE table_name; Example: To delete ‘students’ table. DROP TABLE...

To create a table in a database, we specify a table name, column name and there  datatypes. Syntax: CREATE TABLE...

To create a full backup of the database, we use following syntax: Syntax: BACKUP DATABASE database_name TO DISK = ‘filepath’;...

To delete existing database, we use following syntax: Syntax: DROP DATABASE database_name; Example: To delete learn2done database. DROP DATABASE learn2done;

You may have multiple database but we need to select a specific database to operate on. To use specific database...

To check or see the databases, we use following syntax: Syntax: SHOW DATABASES; This ‘SHOW DATABASES’ statement will show all the...

To create a new database, we use following syntax: Syntax: CREATE DATABASE databasename; Example: The following statement create database named ‘learn2done’...