ASSERT TABLE statement

Wed, 03/04/2009 - 20:02 |  hdanzl


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
‹ Special StatementsupSQL Appendices ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Special Statements

Powered by Drupal and Drupal Theme created with Artisteer.