Questions tagged [table]

Tables are used to organize data into a structured format defined by a fixed number of columns, and an unlimited number of rows. This allows a specific value to be retrieved for an individual column/row cell. In addition to storing data, a table can have associated metadata which may constrain/restrict the data it contains.

To CREATE a table, use the CREATE TABLE command,

• CREATE TABLE PostgreSQL
• CREATE TABLE MySQL
• CREATE TABLE SQL Server

To ALTER a table, use the ALTER TABLE command,

• ALTER TABLE PostgreSQL
• ALTER TABLE MySQL
• ALTER TABLE SQL Server

To delete or DROP a table, use the DROP TABLE command,

• DROP TABLE PostgreSQL
• DROP TABLE MySQL
• DROP TABLE SQL Server

See: Table (database)