DROP DEFAULT JOURNAL TABLE - Teradata Database

SQL Data Definition Language Syntax and Examples
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Database
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-09-23
dita:mapPath
mbm1747160743883.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
mdr1472255012272
lifecycle
latest

Removal of the default status of the journal table currently defined as the default for the specified user.

If the journal table is contained by the user being modified, DROP also drops the table from the system. An error message is returned if the journal table is being used by active data tables.

Specifying this option does not change the status of existing data tables for the modified user.

table_name
The table_name parameter is required if this clause is specified without the DROP keyword.
database_name
If you do not specify a database, then the system assumes the current database by default.
If the database being modified does not have a journal table, table_name is created.
If you specify a different database, then it must already exist and table_name must already be defined as its default journal table.
user_name
If you do not specify a user, then the system assumes the current user by default.
If the user being modified does not have a journal table, table_name is created.
If you specify a different user, then it must already exist and table_name must already be defined as its default journal table.