Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Documentation

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-30 : 13:47:04
shane writes "I have an application (netViz) that we use to document all sorts of things. it can tie directly to any ODBC compliant data and is a lot like Visio but it can be automatically updated and centrally shared. Our primary inventory database is SQL 2000. I want to tie our app to the database to create an automated diagram of the database. The hurdle is I need the table names and field names in a view or a table for the app to connect to. Is there any way to create a query that will grab the table names and field names and put them in a table? then I could create a self documenting database drawing.

Thanks
Shane Johnson"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2006-01-30 : 13:47:04
Take a look at: http://www.sqlteam.com/item.asp?ItemID=7269
Go to Top of Page
   

- Advertisement -