OpenSChema method technology discussion (1)

xiaoxiao2021-03-06  59

?

Get database mode information from the provider.

grammar

SET Connection = Server.createObject ("AdoDb.Connection")

Set Recordset = Connection.Openschema (QueryType, criteria, Schemaid)

return value

Returns the RECORDSET object containing the mode information. Recordset will open read, static cursors.

parameter

QueryType ??? The pattern query type to run can be any constant.

CRITERIA ??? Optional. The query limit condition of each QueryType option,

?

Parameter enumeration (QueryType?)

'---- SchemaEnum Values ​​---- Const adSchemaProviderSpecific = -1Const adSchemaAsserts = 0Const adSchemaCatalogs = 1Const adSchemaCharacterSets = 2Const adSchemaCollations = 3Const adSchemaColumns = 4Const adSchemaCheckConstraints = 5Const adSchemaConstraintColumnUsage = 6Const adSchemaConstraintTableUsage = 7Const adSchemaKeyColumnUsage = 8Const adSchemaReferentialContraints = 9Const adSchemaTableConstraints = 10Const adSchemaColumnsDomainUsage = 11Const adSchemaIndexes = 12Const adSchemaColumnPrivileges = 13Const adSchemaTablePrivileges = 14Const adSchemaUsagePrivileges = 15Const adSchemaProcedures = 16Const adSchemaSchemata = 17Const adSchemaSQLLanguages ​​= 18Const adSchemaStatistics = 19Const adSchemaTables = 20Const adSchemaTranslations = 21Const adSchemaProviderTypes = 22Const adSchemaViews = 23Const adSchemaViewColumnUsage = 24Const adSchemaViewTableUsage = 25Const adSchemaProcedureParameters = 26Const adSchemaForeignKeys = 27Const AdschemaprimaryKeys = 28Const AdschemaprocedureCol UMNS = 29

转载请注明原文地址:https://www.9cbs.com/read-119583.html

New Post(0)