how do i generate SQL script at runtime in VB6.0

how do i Generate SQL Script at ru开发者_如何学Pythonntime from VB6.0 and DB as SQL Server, generate all tables,views,PK,FK.Stored Procedures,Triggers from existing database. thanks in advance.

The simplest way I found to do this sort of thing was to use the SQL Distributed Object Model that you get with SQL Server and it works great with VB6. The last time I tried it was with SQL Server 2000 but the theory should still be good.

Give this link a try as a good start and take it from there, this shows you how to get at the stored procedures http://support.microsoft.com/kb/315505

Once you have got this bit down the other bits you need should be simple enough.

I hope this helps.

Cheers