Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Free
Faster access than browser!
 

Delete (SQL)

Index Delete (SQL)

In the database structured query language (SQL), the DELETE statement removes one or more records from a table. [1]

11 relations: Data definition language, Database, Database trigger, Foreign key, Many-to-many (data model), Referential integrity, Result set, SQL, Table (database), Truncate (SQL), Where (SQL).

Data definition language

A data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.

New!!: Delete (SQL) and Data definition language · See more »

Database

A database is an organized collection of data, stored and accessed electronically.

New!!: Delete (SQL) and Database · See more »

Database trigger

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.

New!!: Delete (SQL) and Database trigger · See more »

Foreign key

In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table.

New!!: Delete (SQL) and Foreign key · See more »

Many-to-many (data model)

In systems analysis, a many-to-many relationship is a type of cardinality that refers to the relationship between two entities A and B in which A may contain a parent instance for which there are many children in B and vice versa.

New!!: Delete (SQL) and Many-to-many (data model) · See more »

Referential integrity

Referential integrity is a property of data stating references within it are valid.

New!!: Delete (SQL) and Referential integrity · See more »

Result set

A SQL result set is a set of rows from a database, as well as metadata about the query such as the column names, and the types and sizes of each column.

New!!: Delete (SQL) and Result set · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: Delete (SQL) and SQL · See more »

Table (database)

A table is a collection of related data held in a structured format within a database.

New!!: Delete (SQL) and Table (database) · See more »

Truncate (SQL)

In SQL, the TRUNCATE TABLE statement is a (DDL) operation that marks the extents of a table for deallocation (empty for reuse).

New!!: Delete (SQL) and Truncate (SQL) · See more »

Where (SQL)

A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria.

New!!: Delete (SQL) and Where (SQL) · See more »

Redirects here:

DELETE, Delete sql, Sql delete.

References

[1] https://en.wikipedia.org/wiki/Delete_(SQL)

OutgoingIncoming
Hey! We are on Facebook now! »