TERADATA Blogger
TERADATA Blogger by Raj
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment