I have 2 databases A and B . There is a table called Details in db A wih 4 fields .The fields are proffesional,amatuer,worldclass,trainee. And I also have a table called Details in db B with 2 fields called proffesional and trainee.

Now what I want to achieve is to convert Table Details schema in db A to that of in db B. How can I achieve this.

Your quick suggestions and feedback would be helpful to me. Thank You

Originally asked by: Pinku Pink on Stack Overflow