/// <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);
}
