Friday, October 24, 2014

how to search object in Netezza box?

we have to use nz_find_object to find object in NPS and it  will check the object in all DB's on NPS server.



nz_find_object table1

  The Object Name Is   | It Is Of Type | Its 'objid' Is | In The Database
-----------------------+---------------+----------------+-----------------
 table1 | TABLE         |       11711150 | DB_name_
 table1 | TABLE         |       10057249 | DB_name__FEB14
 table1 | TABLE         |       11487344 | DB_name__SEP16

No comments:

Post a Comment