Top "Database-table" questions

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

Copy a table from one database to another in Postgres

I am trying to copy an entire table from one database to another in Postgres. Any suggestions?

postgresql copy database-table
Saving changes after table edit in SQL Server Management Studio

If I want to save any changes in a table, previously saved in SQL Server Management Studio (no data in …

sql sql-server ssms database-table
PostgreSQL create table if not exists

In a MySQL script you can write: CREATE TABLE IF NOT EXISTS foo ...; ... other stuff ... and then you can run …

sql postgresql ddl create-table database-table
What is the difference between a schema and a table and a database?

This is probably a n00blike (or worse) question. But I've always viewed a schema as a table definition in …

database schema definition database-table
Create table in SQLite only if it doesn't exist already

I want to create a table in a SQLite database only if doesn't exist already. Is there any way to …

sqlite create-table database-table
Mysql: Select rows from a table that are not in another

How to select all rows in one table that do not appear on another? Table1: +-----------+----------+------------+ | FirstName | LastName | …

mysql sorting unique database-table
Facebook database design?

I have always wondered how Facebook designed the friend <-> user relation. I figure the user table is …

sql facebook database-design database-normalization database-table
Why use multiple columns as primary keys (composite primary key)

This example is taken from w3schools. CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName …

database-design relational-database primary-key ddl database-table
Truncating all tables in a Postgres database

I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this …

postgresql plpgsql dynamic-sql truncate database-table
Table-level backup

How to take table-level backup (dump) in MS SQL Server 2005/2008?

sql-server backup database-table