PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How do you list all the objects available in given database?

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’;

Add a Comment

Your email address will not be published. Required fields are marked *