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

Member

by adan , in category: MySQL , 19 days ago

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

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by larissa , 18 days ago

@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.