copy dbase from the same server sql express (2000 and vb 6.0)

Topic

New Reply

I use a free sql express to store my database, and use vb 6.0 for connection.
I dont know if is possible:
Copy from the database (for example DB_PAST_DUE) the table SPORTELLI (with column, data, setting filed..) and past in the same database with new name SPORTELLI_1… is possible via Sql Command in Sql Express Management studio Express or directlly from a Vb code, admit i just have a connection opened?

Reply | Quote

Replies

You could use the SQL string

SELECT * INTO SPORTELLI_1 FROM SPORTELLI

This will create a new table SPORTELLI_1 and copy all records from SPORTELLI into it.
It will not copy any indexes or triggers into the new table.

Reply | Quote

TKS… work fine naturally!

Reply | Quote