Home All Groups Group Topic Archive Search About

Server Explorer - VS 2005

Author
23 Nov 2007 7:44 AM
Visu
Hi All!

In server explorer when new data connection is added, it shows list of
tables, views and procedures.
I want to get the list of table names, view names and procedure names in a
text file.

Is there any method in .NET or how can we get the names in a text files.

--
Thanks and Regards
S. Viswanathan

Author
24 Nov 2007 2:34 AM
Mr. Arnold
"Visu" <v***@ewaksoft.com> wrote in message
news:%23hlMKQaLIHA.748@TK2MSFTNGP04.phx.gbl...
> Hi All!
>
> In server explorer when new data connection is added, it shows list of
> tables, views and procedures.
> I want to get the list of table names, view names and procedure names in a
> text file.
>
> Is there any method in .NET or how can we get the names in a text files.
>


The free version of Toad for SQL Server, if you're using SQL server, might
be able to do it. I know I was doing a copy/past into Notepad from some
actions I had done with Toad. Not only was Toad  coping the table names but
it also copied the field names as well into Notepad.