Dropping Statistics on a table in teradata

Database
Enthusiast

Dropping Statistics on a table 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
or it needs some modification ...........

[highlight=#ffff11]help need urgently[/highlight]

Thanks in advance
4 REPLIES
Enthusiast

Re: Dropping Statistics on a table in teradata

Vineet,

If you take a look at the manual "SQL Reference: Data Definition Statements", you will be able to find the command "DROP STATISTICS" in detail, which is the command to be used to remove statistics.

If you need further help, just let me know.

Good luck!
Enthusiast

Re: Dropping Statistics on a table in teradata

Hi fabio,

thanks for your reply but can you plz tell me is this manual available online or if i can download it "SQL Reference: Data Definition Statements"

Thanks,
Vineet
Senior Apprentice

Re: Dropping Statistics on a table in teradata

Hi Vineet,
all manuals are available at www.info.teradata.com

I'd recommend to download the documentation CD, so you can search across all manuals.

Dieter
Enthusiast

Re: Dropping Statistics on a table in teradata

Hi All,

Is there any syntax for dropping all the statistics in a schema at once only because it is giving error on dropping individual statistics on every column and i am not able to identify the table where it is giving error.

help needed urgently

THANKS IN ADVANCE