///
///MySql 数据库维护中心///
public classMySqlDbMaintenance:DbMaintenanceProvider
{///
///获取视图信息列表 Sql语句///
protected override string GetViewInfoListSql =>
@"select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables
where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='VIEW'";///
///获取数据表信息列表 Sql语句///
protected override string GetTableInfoListSql => @"select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables
where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='BASE TABLE'";///
///根据数据库表名获取列信息 Sql语句///
protected override stringGetColumnInfosByTableNameSql
{get{string sql = @"SELECT
0 as TableId,
TABLE_NAME as TableName,
column_name AS DbColumnName,
CASE WHEN le