Create view without checking correctness

[mikin]

Hello to everyone!

I have to recreate views in the databases with updated definitions (new database names). But the problem arose, that the views must be created in the order according to their dependancy.

Does anyone know, how to create view without having failures due to unknown database objects?

Thanks,
--mikin

 

[dnoeth]

Hi mikin,
there's a column dbc.tables.CreateTimestamp. If you recreate the views in that order this should be safe.

Dieter