Am looking to find out where does the Checksum metadata values of the datable got stored.
Here when I run a query
CREATE TABLE "ravi"."Table1", FALLBACK , SINGLE BEFORE JOURNAL , CHECKSUM = HIGH (
I can see the Journal options are store in the JournalFlag Column (http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/Database_Management/B035_1092_112...).
Which can be found using the query "select select JournalFlag from DBC.Tables where DatabaseName = 'ravi' and TableName = 'Table1' "
I there any such way to know the value of the Checksum for a given table from the Teradata catalog tables, or is there any store procedure of utility to find out the value of checksum ?
Thanks in advance !!
CHECKSUM can't be found in any system table, it's only in the table header (similar to BLOCKSIZE).