/// <summary> /// 특정 테이블이 존재하는 지 여부를 리턴함. /// </summary> /// <param name="conn">Connection 개체</param> /// <param name="TableName">테이블 이름</param> /// <returns>테이블의 존재 여부</returns> public static bool IsTableExist(SqlConnection conn, string TableName) { string Sql = "select 1 from dbo.sysobjects where id = object_id(N'[" + TableName + "]') and OBJECTPROPERTY(id, N'IsUserTable') = 1"; DataTable dt = CStoredProc.ExecDataTableSql(conn, Sql); return(dt.Rows.Count != 0); }