aspose file tools
The moose likes JDBC and the fly likes segregating Table Synonyms with View Synonyms Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "segregating Table Synonyms with View Synonyms" Watch "segregating Table Synonyms with View Synonyms" New topic
Author

segregating Table Synonyms with View Synonyms

Bhagya Tangutur
Ranch Hand

Joined: Oct 21, 2002
Posts: 88
How can i filter Table Synonyms with View Synonyms.

here is my code snippet which gets all Synonyms from Oracle Database.
String catalog=null;
String schema =mySchmea;
String tableNamePattern="%"
String[] types={"SYNONYMS"};

DatabaseMetaData dbData =referenced with my dbMetaData here.....

Resultset tablesResult = dbData .getTables(catalog, schema, tableNamePattern,types ) ;


This returns me all Synonyms created in the Schema.
Now i have to segregate TableSynonyms from ViewSynonyms.

Thanks


Sun Certified Java Programmer
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 56157
    
  13

"Kumar BT",

We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: segregating Table Synonyms with View Synonyms
 
Similar Threads
To get Database tables
Want to get table names from db in access
table list
getTables schema question
How to get table names ?