/// <summary>
/// 获取数据库内所有表的信息
/// </summary>
/// <param name="databaseName"></param>
/// <returns></returns>
public static DataTable GetTables(string databaseName)
{
DataTable dt = MySqlDbHelper
.Query($"SELECT * FROM information_schema.`TABLES` WHERE TABLE_SCHEMA = '{databaseName}'").Tables[0];
return(dt);
}
/// <summary>
/// 获取表内所有列的详细信息
/// </summary>
/// <param name="tablename"></param>
/// <returns></returns>
public static DataTable GetTableColums(string databaseName, string tablename)
{
DataTable dt = MySqlDbHelper
.Query($@"
SELECT
TABLE_SCHEMA AS '库名',
TABLE_NAME AS '表名',
COLUMN_NAME AS '列名',
ORDINAL_POSITION AS '列的排列顺序',
COLUMN_DEFAULT AS '默认值',
IS_NULLABLE AS '是否为空',
DATA_TYPE AS '数据类型',
CHARACTER_MAXIMUM_LENGTH AS '字符最大长度',
NUMERIC_PRECISION AS '数值精度(最大位数)',
NUMERIC_SCALE AS '小数精度',
COLUMN_TYPE AS 列类型,
COLUMN_KEY 'KEY',
EXTRA AS '额外说明',
COLUMN_COMMENT AS '注释'
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA = '{databaseName}' and TABLE_NAME = '{tablename}'
ORDER BY
TABLE_NAME,
ORDINAL_POSITION;
").Tables[0];
return(dt);
}
/// <summary>
/// 获取数据库连接下所有数据库
/// </summary>
/// <returns></returns>
public static DataTable GetDataBases()
{
DataTable dt = MySqlDbHelper.Query("show DATABASES").Tables[0];
return(dt);
}