drop statistics in teradata

Database
Enthusiast

drop statistics in teradata

I have some multi dimensional statistics defined on a column which i want to drop from the table so i need to drop this statistic first......

Can you tell me the DROP Statement for statistics ?

Is the statement
"""drop statistics on 'table_name' column('column_name')"""
or it needs some modification ...........

help need urgently

Thanks in advance
1 REPLY
Enthusiast

Re: drop statistics in teradata

This is one way of dropping a multi column stats. (There's one more syntax)

DROP STATISTICS ON MyTable COLUMN(col1, col2);

you will notice that the syntax is similar to the collect stats syntax.