Stergerea unei baze de date
Stefanescu Mihai 3 years ago SQL
Acest articol face parte din cursul Toate lectiile SQL.
Te poti inscrie la acest curs aici!
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 | +--------------------+
Get in touch
Pentru nelamuriri, dubii, comentarii si chestii de pe suflet ne putem auzi pe Discord, Reddit sau poti deschide o discutie noua pe forum
upgraded brushless massager
#
8 months ago
Hi there, I enjoy reading all of your article. I like to write
a little comment to support you.
Admiring the dedication you put into your site and detailed
information you provide. It's good to come across a blog
every once in a while that isn't the same out of date rehashed material.
Wonderful read! I've bookmarked your site and I'm including
your RSS feeds to my Google account.
E-wallets are pre-paid accounts used to store cash as well as make on-line repayments.
I'm not sure exactly why but this blog is loading very slow
for me. Is anyone else having this problem or is it a issue on my end?
I'll check back later on and see if the problem still exists.
I read this paragraph fully concerning the
resemblance of hottest and preceding technologies, it's awesome
article.
It's appropriate time to make some plans for the future and it's time to be happy.
I've read this post and if I could I want to suggest you few interesting things or
suggestions. Maybe you can write next articles referring to this article.
I wish to read more things about it!
Hey! This is my first visit to your blog! We are a team of volunteers and starting a new initiative
in a community in the same niche. Your blog provided us
valuable information to work on. You have done a outstanding job!
I am now not certain the place you are getting your information, however
good topic. I must spend some time finding out much more or figuring
out more. Thanks for great info I was on the lookout for this info for my
mission.
Right away I am going away to do my breakfast, after having my breakfast coming again to read other news.