Total Pageviews

Friday 9 November 2012

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

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

1.)select * from dbc.tables where databasename='<DATABASENAME>';

2.) By running a normal help command on that database as follows. 
help database <DATABASENAME';

No comments:

Post a Comment