Sudhakar, This question is a bit high level. What in particular are you having a problem with? Creating a SQL statement to find what tables you have? Creating a stored procedure? Outputting a line of code?
You might have more luck either posting a concrete question or what you have so far.