Top "Database-table" questions

In a relational database management system (RDBMS) a table organizes the information in rows and columns.

How do I get list of all tables in a database using TSQL?

What is the best way to get the names of all of the tables in a specific database on SQL …

sql-server tsql database-table
Copy tables from one database to another in SQL Server

I have a database called foo and a database called bar. I have a table in foo called tblFoobar that …

sql sql-server copy migrate database-table
How can I create a copy of an Oracle table without copying the data?

I know the statement: create table xyz_new as select * from xyz; Which copies the structure and the data, but …

sql oracle copy database-table
How do I specify unique constraint for multiple columns in MySQL?

I have a table: table votes ( id, user, email, address, primary key(id), ); Now I want to make the columns …

mysql unique-constraint composite-key database-table
MySQL > Table doesn't exist. But it does (or it should)

I changed the datadir of a MySQL installation and all the bases moved correctly except for one. I can connect …

mysql exists database-table
Search All Fields In All Tables For A Specific Value (Oracle)

Is it possible to search every field of every table for a particular value in Oracle? There are hundreds of …

sql oracle search plsql database-table
SQL DROP TABLE foreign key constraint

If I want to delete all the tables in my database like this, will it take care of the foreign …

sql-server foreign-keys constraints database-table drop-table
How do you find the row count for all your tables in Postgres

I'm looking for a way to find the row count for all my tables in Postgres. I know I can …

postgresql count database-table
Import CSV to mysql table

What is the best/fastest way to upload a csv file into a mysql table? I would like for the …

mysql csv import load-data-infile database-table
Maximum number of records in a MySQL database table

What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if …

mysql database limit database-table