To view the space occupied by Teradata tables, you can use one of the following methods:
- Connect to a Teradata database using Teradata SQL Assistant or Teradata Studio and execute the following SQL query:
- Retrieve the current and maximum permissions of a specific database and table from the DBC.TableSizeV.
- Replace and
with the names of the database and table you want to view.
- Connect to the Teradata database using Teradata SQL Assistant or Teradata Studio, and run the following SQL query:
- Assistance needed for table .
.
- Replace and
with the names of the database and table you want to view. The query results will display information about the size of the table.
- Use the Teradata Administrator tool to view the information. In Teradata Administrator, select the desired database and table, then right-click and choose the “Properties” option. In the properties window, you can view the size information of the table.
These methods will provide information about the space occupied by Teradata tables, including current permanent space (CurrentPerm) and maximum permanent space (MaxPerm).
✖
