DB with 700 tables and no documentation or source code help
Posted on 2007-11-29
Hi, I am new at my company, and want to figure out which table has what. I have no code or docs from the previous programmers work and must figure it out myself.
Using "Add New Data Source" I can connect to the MS SQL 2000 server and see the ~700 tables. I can add a table, drag it to the form, compile and see the cells in a datagridview. I have gotten a user to save some data, and now I want to look for it, and know where it is.
How can I automate going through the tables and looking for the data that the user saved for me? Here is the code I get in my form when I do the above, and get one of the tables:
Private Sub BsoRelMasterBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BsoRelMasterBindingNavigatorSaveItem.Click
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CompanyADataSet.BsoRelMaster' table. You can move, or remove it, as needed.