Unanswered: I need to know if the table is used by any view
I need to know if the table is used by any view ?
because I need to rename table but I got this message
RENAME TABLE X TO Y
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0750N The statement failed because the table or column cannot be renamed.
when I search about this error I found that I need to drop any view or trigger related to this table before renaming..