Beispiel #1
0
        /// <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);
        }