Stergerea unei baze de date

postat acum 4 ani de Stefanescu Mihai in categorie SQL

Pentru a sterge o baza de date folosim comanda DROP.

DROP DATABASE nume_baza_de_date;

De exemplu, daca dorim s stergem baza de date creata anterior, bdTest folosim urmatoarea comanda:

DROP DATABASE bdTest;

NOTA: Mare atentie la folosirea acestei comenzi pentru ca stergerea unei baze de date duce la pierderea tuturor informatiilor stocate in aceasta.

Pentru a putea sterge o baza de date trebuie sa aveti drepturi de admin.

O data ce o baza de date a fost stearsa se poate verifica existenta ei in lista cu bazele de date astfel:

SQL> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ShopFirst          |
| Invata-Programare  |
| forumPluginDev     |
| WordPressDev       |
+--------------------+
Sunt un tanar programator din Bucuresti ce lucreaza in PHP/Mysql (MySqli/PDO), Laravel, CodeIgniter, MySQL, PostgreSQL, Wordpress, HTML5/CSS3, Sass, Photoshop si multe altele.
Google+ Community Facebook Group
Acest articol a fost mutat de pe vechea platforma.
Pentru orice eroare aparuta la mutare va rog sa ma contactati!

Comentariu postate de minecraft download free pc la data de 14.05.2019
It's really a cool and helpful piece of information. I'm satisfied that you simply shared this useful info with us. Please stay us informed like this. Thank you for sharing.
Comentariu postate de minecraft pc download la data de 15.05.2019
We're a group of volunteers and starting a new scheme in our community. Your web site provided us with valuable info to work on. You've done a formidable job and our whole community will be grateful to you.
Comentariu postate de how to download minecraft free la data de 16.05.2019
My family members always say that I am wasting my time here at net, however I know I am getting knowledge all the time by reading such nice content.