Whenever I create tables in Teradata that contain Foreign Key relationships it seems to create other tables with the same names, but with an underscore and either 0 or 4 in the name. For example:

MYTABLE_0
MYTABLE_4

I can’t see any mention of this in the documentation. Any idea what causes these tables to be created, as I have to now account for them when tearing down schemas that have been created?