Archives of the TeradataForum
Message Posted: Tue, 26 Nov 2002 @ 18:39:26 GMT
<-- Anonymously Posted: Tuesday, November 26, 2002 13:19 -->
Probably a simple question... Where does the system get the table definition to display when a SHOW TABLE request is submitted?
I know it's not DBC.TABLES.REQUESTTEXT. We have a maintenance process that queries DBC.TABLES to assemble the primary index text for tables, using a substring starting with the position of the string 'PRIMARY' and ending at the closing parenthesis. Since an Alter Table request overwrites the table DDL in REQUESTTEXT with the Alter Table statement, the altered tables do not contain 'PRIMARY'. I want to query the equivalent of Show Table output text to get this info.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|