How to get Record Names?

[sandeep43]

Hi

My doubt is when i pass a sql string as input, i should get all record names present in the sql string passed, is there any logic that we can do to get this, please help me out


Regards
Sandeep

[DarrylBurke]

Recommended reading: How to ask questions the smart way

db

[sandeep43]

Hi Darryl

what is wrong in my question most important is how to get that solution man, always you bang on English, you cant expect everyone to be like you, i am weak at English, your are a moderator man you should understand our problem and try giving solution and then recommend us to read, not just always give us link how to improve English and stuff. I am dam sure i have logged into java-forums not English tutorials website.

Regards
Sandeep

[Tolls]

I think Darryl is pointing out that your question, as it stands, makes no sense.
What are you trying to do?
Do you have some code (or at least pseudo code) to show what it is you are trying to figure out?

[sandeep43]

Hi tolls,
i thought you will understand me, because you were the one who usually answer my question more appropriately.

Question is simple tolls, i will fetch sql statements for views present in database, later i want to pass these fetched sql statements one by one such that i have to get TableNames and ViewNames present in fetched sql Statement.

What logic can be employed?

Sandeep

[Tolls]

What do you mean by "fetched SQL statements"?
Do you mean the result sets?

[sandeep43]

Hi Tolls

select OBJECT_DEFINITION(OBJECT_ID('ViewName')) AS TABLE_NAME

if you execute this sql whatever it retrieves is Fetched Sql Statement for that view name.

Sandeep

[Tolls]

It's a resultset (in Java).
Or fetched rows (in most DBs).

Is that what you want to know?
What to do with the ResultSet? That depends on what you want to do with that data.

[sandeep43]

There is nothing to do with ResultSet, i wanted to know how to get TableNames and ViewNames from that Sql Fetched Statements

Sandeep

[Tolls]

No, it's a ResultSet.
Whether the rows in that are simply a list of table names, or some STRUCT or other, is irrelevant.
What is the Type returned by OBJECT_DEFINITION?
What DB are we on here?

[sandeep43]

we are using MS sql server2005, it returns of type varchar

Sandeep

[Tolls]

So what's wrong with:

ResultSet rs = yourSQL.execute();
while (rs.next) {
    System.out.println(rs.getString(1));
}

?
What you do in the loop is entirely up to you. That there will print out all the "TABLENAMES" returned by your query.

[sandeep43]

HI tolls,

I got it, i found better logic, thnks man for helping

Sandeep