Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

Deletion of tables

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

Deletion of tables

Postby Osaou » Wed Apr 16, 2003 3:27 pm

How exactly do you perform this (delete tables)?
And also, how do you delete entire databases?

/Osaou
Osaou
New php-forum User
New php-forum User
 
Posts: 7
Joined: Tue Apr 15, 2003 4:52 pm
Location: Stockholm, Sweden

Postby Flood » Wed Jun 25, 2003 10:44 am

Hi!

I do not know if I have understood the question properly... Do you want the SQL syntax to delete tables and databases, or do you want to know how to do it using phpmyadmin?

I will begin with the second option... Just follow the right path through the interfaces of phpmyadmin :) Select a database, you'll have the list of tables belonging to that database and you can update/delete/empty them. Regarding the deletion of a database itself, move on to the top-level "database"...

Regarding SQL syntax:

Removing a table from a database
DROP TABLE 'table_name';

Deleting a database
DROP DATABASE 'database_name';


Hope it helps...
If not, please be more precise with your question...

/Flood

PS: something completely different: are you a student in Stockholm? Because I live there too! :)
Flood
New php-forum User
New php-forum User
 
Posts: 23
Joined: Tue Jun 24, 2003 4:49 am


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron