copy table from one database to another database

Hi ,



By mistake ,I understood you want to copy on different server .

I have rectify above.On same server we can copy Table in many way ;



As I mentioned Above you can use ;

select * into [Destination Database].[dbo].[NewTableName] from [SourceDatabase].[dbo].[Category]

Second;

select * into [Destination Database].[dbo].[NewTableName] from [SourceDatabase].[dbo].[Category] Where 1=2
Insert into [Destination Database].[dbo].[NewTableName]
select * from [SourceDatabase].[dbo].[Category]

Thanks