A question has been asked in the MSDN Forums regarding the way to copy a Table from another Database to another Database. Well, my first answer was quite simple, use DTS (Data Transformation Services). And the person that questioned asked me where to find that in SQL Server Express. And then it struck me, there's no DTS in SQL Server Express!
So, I went on to find another way to transfer a Table from a database to another database. Manually, you'll have to do these steps:
- Create the Table Structure to the destination Database
- Copy the all data from the source Table to the destination Table
I have arrived with this solution:
(Step 1) - Create Table Structure
Right Click your Table and select Script Table As->CREATE TO->New Query Editor Window

After that, execute the generated query into your destination Database to create the destination Table.
(Step 2) - Copy All Data
To copy all of your data to the destination table just execute a simple INSERT SQL statement like this:
INSERT INTO destDatabase.dbo.TableDestination
SELECT * FROM sourceDatabase.dbo.TableSource
Voila! You now have a copy of your table in your destination Database! Though the downside of this procedure is that your relationships with other Tables will not be generated, which is fine, because some of your Table's dependencies may not be located on your destination Database.