You can create the tables with the structure and with or without data of a previously existing table.
Forget code gives database name also in the syntax to tell that the data sharing is possible even between the different databases.
Please note that the CREATE TABLE AS statement will not work if the source table has referential integrity constraints or any columns are defined as identity columns.