I have two databases, for one I have only read access, and for the other i have read-write access. Let's call them A and B respectively. 

There is a table in A that I need to copy(with its data and structure) into B. 
To copy its structure I have used 'LIKE' keyword, but it did not work out. So, i could not copy the data also.

Do you guys have any further suggestions?
Thank you in advance.