SQLServer Quick Tasks

Deleting Database Objects

--SQLServer performs this action when we right click on any database object and select delete option.
DROP TABLE [dbo].[TableName]
DROP VIEW [dbo].[ViewName]
DROP PROCEDURE [dbo].[ProcedureName]



--Copy Table from one database to another
SELECT * INTO DatabaseName.dbo.DestinationTableName FROM DatabaseName.dbo.SourceTableName;