how can you drop global temp table definition?

Database

how can you drop global temp table definition?

I have to change the structure of GTT definision. I was trying to drop first and then create. Looks like it does not work in teradata.

Please help!  

Thanks

4 REPLIES
Enthusiast

Re: how can you drop global temp table definition?

It does if you have the proper accessright on the table(drop table)

Re: how can you drop global temp table definition?

I have the rights to drop regular table, but I can not drop global temp table. I don't think you can drop global temp table.. Even in docs it does not say that you can

Teradata Employee

Re: how can you drop global temp table definition?

What error did you get? You are not allowed to drop or modify the GTT definition if there are active instances in any session including your own.

It is definately possible to drop the GTT but it has to be currently inactive.

Re: how can you drop global temp table definition?

worked! Thanks