Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create view without checking correctness

Status
Not open for further replies.

mikin

Programmer
Oct 10, 2005
2
CZ
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
 
Hi mikin,
there's a column dbc.tables.CreateTimestamp. If you recreate the views in that order this should be safe.

Dieter
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top