sqlcmd.net validated sql reference

Tag archive

#truncate

Commands grouped around the same concept, pattern, or recurring problem.

2 commands with this tag Browse related patterns quickly
intermediate deleting MySQL MariaDB SQL Server PostgreSQL SQLite

Remove All Rows From A Table With TRUNCATE

Delete every row in a table quickly with TRUNCATE TABLE, which is faster than DELETE with no WHERE clause.

advanced date-time MySQL MariaDB SQL Server PostgreSQL SQLite

Round a Timestamp Down to a Specific Unit

Truncate a timestamp to the start of a month, day, or hour using engine-specific functions.