How to find the total number of columns in a table in teradata?

@adan 

To find the total number of columns in a table in Teradata, you can use the following SQL query:

1
2
3

SELECT COUNT(*)
FROM dbc.ColumnsV
WHERE TableName = 'your_table_name';

Replace 'your_table_name' with the name of the table you want to find the number of columns for. This query will return the total number of columns in the specified table.