copy table

                                           COPY DATATABLE
This blog about copy the table from ine database to another

select * into [Designation path\databasename.MDF]..tablename from [source path\
databasename.MDF]..tablename

Example

select * into [E:\GOMATHI PR COPY\SCHOOL MANGEMENT SYSTEM\SCHOOL MANGEMENT SYSTEM\DB\SHOOLMANAGEMENTSYSTEM.MDF]..tblExamMarksI_A from [E:\SMS(VIDHYA)\SCHOOL MANGEMENT SYSTEM\DB\SHOOLMANAGEMENTSYSTEM.MDF]..tblExamMarksI_A