I need to create a table in database B that has the same schema as a table in database A. How do I do this ? I also want to add some additional columns.

I tried using a "CREATE TABLE ...." SQL statement, but there doesn't seem to be any way to provide the necessary column information needed to create the table.

I tried experimenting with the DataColumn type, but it doesn't seem to provide enough information. All I want to do basically is copy the table structure.

Do I have to write some sort of conversion routine to convert the DataColumn information into strings that SQL can digest, or is there an easier way ?