config.GetTableSize C# (CSharp) 메소드

GetTableSize() 개인적인 메소드

private GetTableSize ( string tableName ) : string
tableName string
리턴 string
    private string GetTableSize(string tableName)
    {
        decimal size = 0;
        string sql;
        DataSet d;

        sql = "SELECT SUM( data_length + index_length) / 1024 / 1024 AS size FROM information_schema.TABLES WHERE table_schema = 'OSAE' AND TABLE_NAME = '" + tableName + "';";
        d = OSAESql.RunSQL(sql);
        size = (decimal)d.Tables[0].Rows[0]["size"];
        return String.Format("{0:0.##}", size) + "Mb";
    }