Database replication query

I am somewhat new to SQL etc and hope someone will be able to assist me. I have established a new MS-SQL database on my (local) server and in my Database Manager now wish to establish in it the exact same tables that are in another database. It is quite a large d/b and would take some time to completely replicate 'manually' so am looking for a query that I can run that would access the other d/b, read the tables data and create the same tables in the new d/b. Is this possible or not possible/practical? Thanks (in anticipation).