Differentiating Between normal table and global temp table
If an user has 150 tables and 100 is normal table and 50 is global temporary table, how do I count and make a list for the 100 normal tables and 50 global temporary tables.
Which table properties should I use to differentiate between these two type of tables?
Thanks.