Archives of the TeradataForum
Message Posted: Fri, 18 Feb 2005 @ 12:27:37 GMT
I have doubt in this query.
I dont want to compare the table "NAME" and the View "Name". They will never be same.
I want to see what all tables are referred to in the view "DEFINITION".
Select trim(databasename) || '.' || trim(tablename) From dbc.tables Where (trim(databasename) || '.' || trim(tablename)) in ( 'Your Database.Your Table With New Columns' ,.... ) and TableKind = 'V'
Thanks and Regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|