DROP DATABASE statement in SQL

-
The DROP DATABASE statement is used to drop the existing database.

Syntax:

 DROP DATABASE databasename;

 DROP DATABASE EXAMPLE

DROP DATABASE test;



Note: Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database!

Make sure you have admin privilege before dropping any database otherwise you will not able to drop the database. Once a database is dropped, you can check it in the list of databases with the following SQL command: SHOW DATABASES;

Comments

Post a Comment

Popular posts from this blog

Hyperparameter tuning for machine learning models.

-
Image
When creating a machine learning model, you'll be presented with design choices as to how to define your model architecture. Often times, we don't immediately know what the optimal model architecture should be for a given model, and thus we'd like to be able to explore a range of possibilities. In true machine learning fashion, we'll ideally ask the machine to perform this exploration and select the optimal model architecture automatically. Parameters which define the model architecture are referred to as  hyperparameters  and thus this process of searching for the ideal model architecture is referred to as  hyperparameter tuning . Whereas the model parameters specify how to transform the input data into the desired output, the hyperparameters define how our model is actually structured. Unfortunately, there's no way to calculate “which way should I update my hyperparameter to reduce the loss?” (ie. gradients) in order to find the optimal model architecture; thu...
Read more

What is difference between Yield and return Keyword in Python

-
Image
Yield Keyword In Python : Return sends/return specific value back to its caller function whereas Yield can produce a sequence of values. we can use yield when we want to iterate over a sequence but don't want to store the entire sequence in the memory  Yield are used in python generator. A generator function is defined as a normal function but whenever it needs to generate a value,  yield is used instead of return. if any function contains a yield then it will automatically become a generator function 
Read more