For handling huge data every year, we r creating diffrerent databases for each year (DB0203) on New Financial Year which will reside on the same server.
I wanted to know abt Sql Syntax or some other method which i could handle from VB, which will Copy the Table structres & Relationships of DB0102 to DB0203. I want to copy just the structure of tables & relationships & not the data in it?
I am using Sql Servr 7
__________________
______________________________
- Regards Rohan (India,Mumbai)
I wanted to know abt Sql Syntax or some other method which i could handle from VB, which will Copy the Table structres & Relationships of DB0102 to DB0203. I want to copy just the structure of tables & relationships & not the data in it?
I am using Sql Servr 7
__________________
______________________________
- Regards Rohan (India,Mumbai)