Deleting all baselines from a repository in one go

[adepreter]

What is the most effective way to delete all baselines from the repository in one go.

Is all baseline information stored ONLY in the t_document table (where t_document.ElementID = t_package.ea_guid) ?

Thanks

Alain

[Geert Bellekens]

Alain,

I believe it is indeed only stored in the t_document, but it is not the only thing that is stored in that table.
So you'll have to make sure that your selection is precise enough to delete ONLY the baselines.

Geert

[qwerty]

Code: [Select]

DELETE FROM t_document WHERE ElementType="Baseline"should do. See p. 28 of my Inside book.

q.

[adepreter]

Thank you very much! I guess you meant DocType and not ElementType.

DELETE FROM t_document WHERE DocType="Baseline"

[qwerty]

Yes. It looks like I need to clarify the according paragraph in my book

q.