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

Truncate (SQL)

Index Truncate (SQL)

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

14 relations: Commit (data management), Database trigger, Delete (SQL), Identity column, Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, Record locking, SQL, SQL:2008, Table (database), Transaction log, Where (SQL).

Commit (data management)

In computer science and data management, a commit is the making of a set of tentative changes permanent.

New!!: Truncate (SQL) and Commit (data management) · 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!!: Truncate (SQL) and Database trigger · See more »

Delete (SQL)

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

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

Identity column

An identity column is a column (also known as a field) in a database table that is made up of values generated by the database.

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

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft.

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

MySQL

MySQL ("My S-Q-L") is an open-source relational database management system (RDBMS).

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

Oracle Database

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.

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

PostgreSQL

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

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

Record locking

Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.

New!!: Truncate (SQL) and Record locking · 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!!: Truncate (SQL) and SQL · See more »

SQL:2008

SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language.

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

Table (database)

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

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

Transaction log

In the field of databases in computer science, a transaction log (also transaction journal, database log, binary log or audit trail) is a history of actions executed by a database management system used to guarantee ACID properties over crashes or hardware failures.

New!!: Truncate (SQL) and Transaction log · 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!!: Truncate (SQL) and Where (SQL) · See more »

Redirects here:

Truncate table.

References

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

OutgoingIncoming
Hey! We are on Facebook now! »