I'm very new at using Teradata and I have a question about a partitioned table. When I create a partitioned table, how do I verify that the partitions were set up as I intended BEFORE any data is loaded into the table? Is there a query I can run against one or more DBC tables to provide me that information? I know there are queries that can be ran AFTER data is loaded into the table, but I'm looking for a more proactive approach to ensure my partitions are set up correctly right after my table is created (I'm looking for that warm, fuzzy feeling that it got created correctly).
I'm coming from a DB2 environment where I can easily see this so I figured Teradata would have this same type of information stored somewhere in one or more of its DBC tables.