MySqlConnector


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
  • Databases
  • 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
  • SchemaPrivileges
  • Tables
  • TableConstraints
  • TablePrivileges
  • TableSpaces
  • Triggers
  • UserPrivileges
  • Views

The GetSchema(string, string[]) overload that specifies restrictions is not supported.