NexusDB Guide > SQL Reference > SQL Statements > Special Statements

NexusDB V3 Manual

ASSERT TABLE statement

NexusDB Manual V3 > SQL Reference > SQL Statements > Special Statements

Syntax

<assert table statement> ::= ASSERT TABLE table-name = TABLE table-name

Usage

The assert table statement checks if the two tables have identical column definitions and row data, and throws an exception if any difference is detected.

Examples

1)	ASSERT TABLE students = TABLE students_backup_20040810;

Conformance

NexusDB extensions

ASSERT TABLE statement

nexus_logo