|
I need to drop all the tables in a database without knowing their names beforehand. The typical procedure is to drop and then recreate the database but this is not an option. What is the best way to to it?
Started by Angel Chiang on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
There was an entry on the Xaprb blog recently which covers this nicely <databaseName> -N -e 'show... .
You should use the information_schema tables to fetch the metadata about the database, and then drop the tables listed there.
|
|
Does the MySQL command :
FLUSH TABLES;
flush every table in the current database, or every table on the server ?
I'm using MySQL 5.0 - the documentation is unclear, although it does mention that :
FLUSH TABLES WITH READ LOCK;
will do so for ALL databases...
Started by Richard on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
There is no mention of database-specific table caches, there seems to be only one_error(): No Database selected
with "flush tables" there is no mysql_error, so i think the answer, as you did.
Recently used tables.
|
|
Let's say I want to build a gaming website and I have many game sections. They ALL have a lot of data that needs to be stored. Is it better to make one database with a table representing each game or have a database represent each section of the game?...
Started by Doug on
, 17 posts
by 17 people.
Answer Snippets (Read the full thread at stackoverflow):
Why that information."
Managing....
I'm not sure this is correct, but I think you want to do one database with 5 tables because (along I would always opt for one database absent a specific and convincing reason for doing otherwise.
|
Ask your Facebook Friends
|
I can use select * from sys.tables in mssql to show a list of all tables in the current database. Is there anyways I can use similar syntax to show list of tables in another database?
Say I am using A with use A statement, can I show tables in database...
Started by Haoest on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
To use your example:
use a; go select * from sys.tables; -- selects table info * from your_database_name.information....
This does it for me (MS SQL 2005 and newer):
select * from your_database_name.sys.tables
Keep on that database.
|
|
How do I drop all empty tables from a MySQL database leaving only the tables that have at least 1 record?
Started by Frank Malina on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
table, because I did not found a way to perform one query on all tables in one query)
It is the same do it:
DELIMITER $$ DROP PROCEDURE IF EXISTS `drop_empty_tables_from` $$ CREATE PROCEDURE `drop_empty_tables_from`(IN schema....
|
|
I want to be able to create a PDF or an image of a MySQL database. It should have one box per table and each box should list all the columns in the table. I don't need lines going between various forgein keys or show info on default types or even the ...
Started by Rory McCann on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
Here is a table containing all features for the different database of your database.
This report can be exported to PDF.
Dbdesc includes a built-in report engine and report viewer to easily browse database documentation.
|
|
Is there a way to enable STRICT_ALL_TABLES for a single MySQL database?
Started by Greg on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Set sql_mode = 'STRICT_ALL_TABLES'; will do it..
Could do this in the config files of specific users .
Session when working on a particular database.
|
|
My database is not in UTF8, and I'd like to convert all the tables to UTF8, how can I do this?
Thank you.
Started by nubela on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname CHARACTER SET utf8 COLLATE this:
ALTER TABLE tab CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
For the whole database I don't-mysql-tables....
|
|
Delete all rows from all tables in a SQL Server database
Started by surajit khamrai on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Always a good idea to have the full db creation scripts anyway so that may be the easiest .
From all tables using an approach like Rubens suggested, or you could just drop and recreate all the tables.
|
|
What is the best way to get the names of all of the tables in a specific database on SQL Server?
Started by Ray Vega on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
U'
How can I do the equivalent of “SHOW TABLES” in T-SQL?
SELECT sobjects.name FROM sysobjects/questions/465014/list-table-names
http://stackoverflow.com/questions/420741/getting-list-of-tables-and-fields-in-each-in-a-database....
|
