Entries from The Shorten Spot tagged with 'tables'
SQL to list tables for a DB Process
To list the tables that are included in a Database Process (DB Process) you can use the following SQL: SELECT DISTINCT m.tbl_name as "Table Name" FROM ci_md_mo_tbl m, ci_db_instr d WHERE m.maint_obj_cd = d.maint_obj_cd AND d.DB_PROC_CD = 'CI_COCNT' order by...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'tables'.
