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! 😀 )