All Forums Database
mihirdhakan93 14 posts Joined 04/15
15 Oct 2015
Comparing Two Environment

Hi,
I need to write a Stored Procedure to compare two Environment's(eg. Dev1_stg with Dev12_stg) Tables, Stored Procedure, UDF, Especially Views. Can any one suggest how can i approach this concept in Stored Procedure? 
I am able to do this comparison for Tables, using Dbc.ColumnsV. but for Stored Procedures, Views?
Thanks!
 

dins2k2 51 posts Joined 05/13
20 Oct 2015

Hi,
There is a column named TableKind in dbc.tables which tells you what kind of object(eg: Table, View, Procedure, Macro, etc). You can use this column to compare the all kind of objects in the database. Below link for your reference.
 
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1092_111A/Appendix_A_System_Columns.017.19.html

Thanks,
Dinesh

You must sign in to leave a comment.