IMyMetaPluginContext.CreateDatabasesDataTable
public DataTable CreateDatabasesDataTable()
{
DataTable table = new DataTable();
table.Columns.Add("CATALOG_NAME", Type.GetType("System.String"));
table.Columns.Add("DESCRIPTION", Type.GetType("System.String"));
table.Columns.Add("SCHEMA_NAME", Type.GetType("System.String"));
table.Columns.Add("SCHEMA_OWNER", Type.GetType("System.String"));
table.Columns.Add("DEFAULT_CHARACTER_SET_CATALOG", Type.GetType("System.String"));
table.Columns.Add("DEFAULT_CHARACTER_SET_SCHEMA", Type.GetType("System.String"));
table.Columns.Add("DEFAULT_CHARACTER_SET_NAME", Type.GetType("System.String"));
return table;
}
|
IDatabase |
DataTable Column |
Remarks |
|
Name |
CATALOG_NAME |
|
|
Description |
DESCRIPTION |
|
|
SchemaName |
SCHEMA_NAME |
|
|
SchemaOwner |
SCHEMA_OWNER |
|
|
DefaultCharSetCatalog |
DEFAULT_CHARACTER_SET_CATALOG |
|
|
DefaultCharSetSchema |
DEFAULT_CHARACTER_SET_SCHEMA |
|
|
DefaultCharSetName |
DEFAULT_CHARACTER_SET_NAME |
|
IMyMetaPluginContext.CreateTablesDataTable
public DataTable CreateTablesDataTable()
{
DataTable metaData = new DataTable();
metaData.Columns.Add("TABLE_SCHEMA", Type.GetType("System.String"));
metaData.Columns.Add("TABLE_NAME", Type.GetType("System.String"));
metaData.Columns.Add("TABLE_TYPE", Type.GetType("System.String"));
metaData.Columns.Add("TABLE_GUID", Type.GetType("System.Guid"));
metaData.Columns.Add("DESCRIPTION", Type.GetType("System.String"));
metaData.Columns.Add("TABLE_PROPID", Type.GetType("System.Int64"));
metaData.Columns.Add("DATE_CREATED", Type.GetType("System.DateTime"));
metaData.Columns.Add("DATE_MODIFIED", Type.GetType("System.DateTime"));
return metaData;
}
|
ITable |
DataTable Column |
Remarks |
|
|
TABLE_CATALOG |
Not used |
|
Schema |
TABLE_SCHEMA |
|
|
Name |
TABLE_NAME |
|
|
Type |
TABLE_TYPE |
|
|
Guid |
TABLE_GUID |
|
|
Description |
DESCRIPTION |
|
|
PropID |
TABLE_PROPID |
|
|
DateCreated |
DATE_CREATED |
|
|
DateModified |
DATE_MODIFIED |
|
IMyMetaPluginContext.CreateColumnsDataTable
public DataTable CreateColumnsDataTable()
{
DataTable metaData = new DataTable();
metaData.Columns.Add("TABLE_CATALOG", Type.GetType("System.String"));
metaData.Columns.Add("TABLE_SCHEMA", Type.GetType("System.String"));
metaData.Columns.Add("TABLE_NAME", Type.GetType("System.String"));
metaData.Columns.Add("COLUMN_NAME", Type.GetType("System.String"));
metaData.Columns.Add("COLUMN_GUID", Type.GetType("System.Guid"));
metaData.Columns.Add("COLUMN_PROPID", Type.GetType("System.Int64"));
metaData.Columns.Add("ORDINAL_POSITION", Type.GetType("System.Int64"));
metaData.Columns.Add("COLUMN_HASDEFAULT", Type.GetType("System.Boolean"));
metaData.Columns.Add("COLUMN_DEFAULT", Type.GetType("System.String"));
metaData.Columns.Add("COLUMN_FLAGS", Type.GetType("System.Int64"));
metaData.Columns.Add("IS_NULLABLE", Type.GetType("System.Boolean"));
metaData.Columns.Add("DATA_TYPE", Type.GetType("System.Int32"));
metaData.Columns.Add("TYPE_NAME", Type.GetType("System.String"));
metaData.Columns.Add("TYPE_GUID", Type.GetType("System.Guid"));
metaData.Columns.Add("CHARACTER_MAXIMUM_LENGTH", Type.GetType("System.Int64"));
metaData.Columns.Add("CHARACTER_OCTET_LENGTH", Type.GetType("System.Int64"));
metaData.Columns.Add("NUMERIC_PRECISION", Type.GetType("System.Int32"));
metaData.Columns.Add("NUMERIC_SCALE", Type.GetType("System.Int16"));
metaData.Columns.Add("DATETIME_PRECISION", Type.GetType("System.Int64"));
metaData.Columns.Add("CHARACTER_SET_CATALOG", Type.GetType("System.String"));
metaData.Columns.Add("CHARACTER_SET_SCHEMA", Type.GetType("System.String"));
metaData.Columns.Add("CHARACTER_SET_NAME", Type.GetType("System.String"));
metaData.Columns.Add("COLLATION_CATALOG", Type.GetType("System.String"));
metaData.Columns.Add("COLLATION_SCHEMA", Type.GetType("System.String"));
metaData.Columns.Add("COLLATION_NAME", Type.GetType("System.String"));
metaData.Columns.Add("DOMAIN_CATALOG", Type.GetType("System.String"));
metaData.Columns.Add("DOMAIN_SCHEMA", Type.GetType("System.String"));
metaData.Columns.Add("DOMAIN_NAME", Type.GetType("System.String"));
metaData.Columns.Add("DESCRIPTION", Type.GetType("System.String"));
metaData.Columns.Add("COLUMN_LCID", Type.GetType("System.Int32"));
metaData.Columns.Add("COLUMN_COMPFLAGS", Type.GetType("System.Int32"));
metaData.Columns.Add("COLUMN_SORTID", Type.GetType("System.Int32"));
metaData.Columns.Add("IS_COMPUTED", Type.GetType("System.Boolean"));
metaData.Columns.Add("IS_AUTO_KEY", Type.GetType("System.Boolean"));
metaData.Columns.Add("AUTO_KEY_SEED", Type.GetType("System.Int32"));
metaData.Columns.Add("AUTO_KEY_INCREMENT", Type.GetType("System.Int32"));
return metaData;
}
|
IColumn |
DataTable Column |
Remarks |
|
|
TABLE_CATALOG |
Not used |
|
|
TABLE_SCHEMA |
Not used |
|
|
TABLE_NAME |
Not used |
|
Name |
COLUMN_NAME |
|
|
Guid |
COLUMN_GUID |
|
|
PropID |
COLUMN_PROPID |
|
|
Ordinal |
ORDINAL_POSITION |
|
|
HasDefault |
COLUMN_HASDEFAULT |
|
|
Default |
COLUMN_DEFAULT |
|
|
Flags |
COLUMN_FLAGS |
|
|
IsNullable |
IS_NULLABLE |
|
|
DataType |
TYPE_NAME |
Native Database Type |
|
DataTypeName |
** |
Calculated for your by Mapping IColumn.NativeType to it's corresponding entry in the language mapping xml file |
|
TypeGuid |
TYPE_GUID |
|
|
CharacterMaxLength |
CHARACTER_MAXIMUM_LENGTH |
|
|
CharacterOctetLength |
CHARACTER_OCTET_LENGTH |
|
|
NumericPrecision |
NUMERIC_PRECISION |
|
|
NumericScale |
NUMERIC_SCALE |
|
|
DateTimePrecision |
DATETIME_PRECISION |
|
|
CharacterSetCatalog |
CHARACTER_SET_CATALOG |
|
|
CharacterSetSchema |
CHARACTER_SET_SCHEMA |
|
|
CharacterSetName |
CHARACTER_SET_NAME |
|
|
DomainCatalog |
DOMAIN_CATALOG |
|
|
DomainSchema |
DOMAIN_SCHEMA |
|
|
DomainName |
DOMAIN_NAME |
|
|
Description |
DESCRIPTION |
|
|
LCID |
COLUMN_LCID |
|
|
CompFlags |
COLUMN_COMPFLAGS |
|
|
SortID |
COLUMN_SORTID |
|
|
IsComputed |
IS_COMPUTED |
|
|
IsAutoKey |
IS_AUTO_KEY |
|
|
AutoKeySeed |
AUTO_KEY_SEED |
|
|
AutoKeyIncrement |
AUTO_KEY_INCREMENT |
|