copy table from one database to another database

Hi ,



You can use below Query;

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

[SourceDatabase]: where you want to Copy Destination

[Destination Database]: From where you want to copy Source

Thanks