In SQL Server 2014 (maybe also in earlier versions) SWITCHing unpartitioned tables is easy.
Example:
(Summary: SWITCHing between T1 and T2)
--Table/Index creation
CREATE TABLE [dbo].[T1] ( [A] [INT] PRIMARY KEY);
CREATE TABLE [dbo].[T2] ( [A] [INT] PRIMARY KEY);
GO
-- Populate some example table data
DECLARE @val INT = 1;
WHILE @val < 100
BEGIN
INSERT INTO dbo.T1(A) VALUES (@val);
SELECT @val=@val+1;
END;
-- Switch the two tables
ALTER TABLE dbo.T1 SWITCH TO T2;
-- Switch again
ALTER TABLE dbo.T2 SWITCH TO T1;
Perfect for a some cases! 🙂
(Edit: I had fogotten to include the actual SWITCH code! 😀 )