drop journal tables.

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

drop journal tables.

Rate Topic

Display Mode

Topic Options

Author

Message

shivatera

Posted 7/2/2009 5:25:43 AM

Forum Newbie

Group: Forum Members
Last Login: 8/6/2009 6:58:27 AM
Posts: 4, Visits: 9

I have some databases which has some journal tables. I want to drop the journal tables. Can anyone suggest the how to drop the journal tables.

Post #15997

dnoeth

Posted 7/2/2009 1:44:11 PM

Supreme Being

Group: Forum Members
Last Login: 11/5/2009 4:40:02 PM
Posts: 717, Visits: 466

How did you create the journal? This is how to drop it, too.

modify database xxx as drop default journal table;

Dieter

Post #16017

shivatera

Posted 7/7/2009 1:41:00 AM

Forum Newbie

Group: Forum Members
Last Login: 8/6/2009 6:58:27 AM
Posts: 4, Visits: 9

Thanks dnoeth

Post #16063

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 1:20am