Hi there.

I am very new to this, and we are kind of going to start doing this for a project.

I need to know, is it possible to detect the structure of a table in a specified database in SQL?

if so - how would you do that? what is brought back from sql when requested?


The other thing is....

when it comes to populating a database, how do you populate the database by record? I mean, lets say if table A has 5 fields, and table B has 9 fields, how do you populate the tables (auto detecting) for all fields in the table?

Thank-you