if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_SUPO_BBS_FILE]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[SUPO_BBS_FILE] DROP CONSTRAINT FK_SUPO_BBS_FILE
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SUPO_BBS_FILE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SUPO_BBS_FILE]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SUPO_BBS_LIST]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SUPO_BBS_LIST]
GO

CREATE TABLE [dbo].[SUPO_BBS_FILE] (
 [BBS_ID] [char] (6) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [BBS_SEQ] [int] NOT NULL ,
 [FILE_SEQ] [int] NOT NULL ,
 [FILE_PATH] [varchar] (255) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [FILE_NM] [varchar] (255) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [FILE_STRG_NM] [varchar] (40) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [FILE_SIZE] [varchar] (9) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [FILE_CTYPE] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SUPO_BBS_LIST] (
 [BBS_ID] [char] (6) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [BBS_SEQ] [int] NOT NULL ,
 [ANSW_RFRN] [int] NOT NULL ,
 [ANSW_SEQ] [smallint] NOT NULL ,
 [ANSW_LVL] [smallint] NOT NULL ,
 [COMP_ID] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [USR_ID] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [USR_NM] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [USR_MAIL] [varchar] (100) COLLATE Korean_Wansung_CI_AS NULL ,
 [USR_IP] [varchar] (25) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [TITL] [varchar] (255) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [BRWS_CNT] [int] NOT NULL ,
 [REG_DT_TM] [datetime] NOT NULL ,
 [UPD_DT_TM] [datetime] NOT NULL ,
 [BGN_PRD] [datetime] NULL ,
 [END_PRD] [datetime] NULL ,
 [HTML_YN] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [DEL_YN] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [EVT_YN] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [CONT] [text] COLLATE Korean_Wansung_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

이렇게 em에서 다른 섭의 db의 bbs스크립트를 가져와서 실행시키면 collate에러가 나는데 왜 그런지 ㅡㅡa 급해염....