/// <summary> /// 특정 테이블을 만듦. /// </summary> /// <param name="conn">Connection 개체</param> /// <param name="TableName">만들어질 테이블 이름</param> /// <param name="aSqlColumnInfo">만들어질 테이블의 열 정보</param> public static void CreateTable(SqlConnection conn, string TableName, SqlColumnInfo[] aSqlColumnInfo) { string Sql = "create table [" + TableName + "] (\r\n"; string SqlBody = ""; string DataTypeCur = ""; for (int cl = 0, cl2 = aSqlColumnInfo.Length; cl < cl2; cl++) { DataTypeCur = aSqlColumnInfo[cl].DataType.ToString(); if (aSqlColumnInfo[cl].Length != 0) { DataTypeCur += "(" + aSqlColumnInfo[cl].Length + ")"; } SqlBody += ",\r\n[" + aSqlColumnInfo[cl].Name + "] " + DataTypeCur; } SqlBody = SqlBody.Substring(3); Sql = Sql + SqlBody + ")"; CStoredProc.ExecUpdateSql(conn, Sql); }
/// <summary> /// 특정 테이블의 이름을 변경함. /// </summary> /// <param name="conn">Connection 개체</param> /// <param name="TableNameOld">현재 테이블 이름</param> /// <param name="TableNameNew">변경될 테이블 이름</param> public static void RenameTable(SqlConnection conn, string TableNameOld, string TableNameNew) { string Sql = "sp_rename '[" + TableNameOld.Replace("[", "[[").Replace("]", "]]") + "]', '" + TableNameNew + "'"; CStoredProc.ExecUpdateSql(conn, Sql); }
/// <summary> /// 특정 테이블을 삭제함. /// </summary> /// <param name="conn">Connection 개체</param> /// <param name="TableName">테이블 이름</param> public static void DropTable(SqlConnection conn, string TableName) { string Sql = "drop table [" + TableName + "]"; CStoredProc.ExecUpdateSql(conn, Sql); }