Archives of the TeradataForum

Message Posted: Mon, 27 Mar 2006 @ 23:58:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You can create an store procedure to drive such action as dropping a table as result of the search for another object.

The query could be something like this :

     Create procedure
     ...
     if
     Select 'Exist' where exists (select databaseid, tvmname from dbc.tvm
      where databaseid in (select distinct databaseid from dbc.dbase where
     databasename = :dbo)
      and tvmname = :tablename and tablekind = 'T')
     ...
     Then
     Database :dbo;
     Drop table :tablename;
     ...

You must have select access to dbc database

This is just an approach, I hope this help.

Regards

Alejandro

__________________________
L. Alejandro Lopez Trigos
NCR Mexico
Data Warehouse Consultant
Teradata Certified Professional

	<Prev	Next>		<<First	<Prev	Next>	Last>>