CALCULATING THE NUMBER OF COLUMNS OF A SPECIFIC TABLE

Database
Enthusiast

CALCULATING THE NUMBER OF COLUMNS OF A SPECIFIC TABLE

Hi ALL,
I need to calculate the number of columns of specific tables in Teradata indeed. I searched & tried but none of my solutions work. is there a way to do so. any suggestion will be appreciated.

Thank you,
2 REPLIES
Junior Contributor

Re: CALCULATING THE NUMBER OF COLUMNS OF A SPECIFIC TABLE

Column information for all tables can be found in dbc.ColumnsV

Dieter
Enthusiast

Re: CALCULATING THE NUMBER OF COLUMNS OF A SPECIFIC TABLE

Thank you so much, your answer did really help me :)