Create DB, table, index in a SQL Server 2000 by code

[rr3news]

How can i create a database, tables and index in a SQL Server 2000 using ADOX, ADO and VB6

Thank You

 

[Dimandja]

Try googling a bit.

I quickly came up with

http://www.vb-helper.com/howto_adox_create_database.html

 

[fredericofonseca]

look at SQL Server books online (supplied with SQL Server)
search for create (database, table and index)

You will find the SQL code required for that.

Then you just use ADO to execute the correct SQL statements as you would do with ANY other SQL statement.




Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com