How do you list all the objects available in given database? TDWORLD | May 24, 2014 | Important Queries | No Comments 2) How do you list all the objects available in given database? Answers) select * from dbc.tables where databasename=’<DATABASENAME>’; By running a normal help command on that database as follows. help database <DATABASENAME’; Related Posts How to find the space utilized by particular database in teradata ? No Comments | May 24, 2014 How to generate list of tables having UNNECESSARY CASESPECIFIC defined in column ? No Comments | May 24, 2014 When I get an error stating 'NO MORE SPOOL SPACE IN USER' what does it mean? No Comments | May 24, 2014 How to generate the list of database's which are not used by any user in Teradata warehouse ? No Comments | May 24, 2014 About The Author tdworld2013 Add a Comment Cancel reply Your email address will not be published. Required fields are marked *Comment:*Name:* Email Address:* Website: Save my name, email, and website in this browser for the next time I comment.