Supported Schema Collections

DbConnection.GetSchema retrieves schema information about the database that is currently connected. For background, see MSDN on GetSchema and Schema Collections and Common Schema Collections.

MySqlConnection.GetSchema supports the following schemas:

• MetaDataCollections—information about available schemas
• CharacterSets
• Collations
• CollationCharacterSetApplicability
• Columns—information about columns (in all tables)
• Databases
• DataSourceInformation
• DataTypes—information about available data types
• Engines
• KeyColumnUsage
• KeyWords
• Parameters
• Partitions
• Plugins
• Procedures—information about stored procedures
• ProcessList
• Profiling
• ReferentialConstraints
• ReservedWords—information about reserved words in the server’s SQL syntax
• ResourceGroups
• Restrictions—information about the restrictions supported when retrieving schemas
• SchemaPrivileges
• Tables—information about tables
• TableConstraints
• TablePrivileges
• Triggers
• UserPrivileges
• Views
• Foreign Keys—[information about foreign keys in the server’s SQL syntax](../schema/foreign keys/)
• Indexes—information about indexes in the server’s SQL syntax
• IndexColumns—information about indexes in the server’s SQL syntax