Copying Database objects between 2 Database using VB

[kiranpchandran]

Hello,

I am using VB6 and SQL Server 2000. Is there any method for coping database objects(Table (without data), procedure,views,etc) from one database to another by running a script from VB.

Thanks in advance
Kiran

Aum Namah Shivaya

[Iouri]

for SQL server it must be something like this. It must create a new table.
insert into db2.dbo.table2 select * from db1.dbo.table1

Iouri Boutchkine
iouri@hotsheet.com