if object_id('Table1') is not null
drop table dbo.Table1
Create table dbo.Table1
(
 c1 int
,c2 varchar(150)
,c3 varchar(150)
,c4 nvarchar(150)
)

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

exec ('select top 0 * into dbo.table2 from dbo.Table1 ')
exec ('alter table  dbo.table2 add constraint default_c4 default ''N/A'' for c4')