OpenSchema
ADO OpenSchema metodi
❮ Connection obyektining to‘liq ma’lumotnomasi
OpenSchema metodi provayderdan olingan ma’lumotlar manbai haqidagi sxema ma’lumotlarini o‘z ichiga olgan Recordset obyektini qaytaradi. Masalan, sxema ma’lumotlari jadvallar nomlari, jadvallardagi ustunlar nomlari va har bir ustunning ma’lumot tipini o‘z ichiga olishi mumkin. Recordset faqat o‘qish uchun mo‘ljallangan recordset (yozuvlar to‘plami) sifatida ochiladi.
Sintaksis
Set rs=objconn.OpenSchema(querytype,criteria,schemaid)
| Parametr | Tavsif |
|---|---|
| querytype | Majburiy. Bajariladigan sxema so‘rovining turini ifodalovchi SchemaEnum qiymati Eslatma: OLEDB spetsifikatsiyasi SchemaEnum qiymatlaridan faqat 3 tasining qo‘llab-quvvatlanishini talab qiladi. Ular: adSchemaTables, adSchemaColumns va adSchemaProviderTypes |
| criteria | Ixtiyoriy. SchemaEnum jadvalida keltirilganidek, har bir querytype varianti uchun so‘rov cheklovlari massivi |
| schemaid | OLE DB spetsifikatsiyasida aniqlanmagan provayder sxemasi so‘rovi uchun GUID. Agar querytype adSchemaProviderSpecific qiymatiga o‘rnatilgan bo‘lsa, majburiy |
SchemaEnum qiymatlari
| Konstanta | Qiymat | Tavsif | Cheklov ustunlari |
|---|---|---|---|
| adSchemaProviderSpecific | -1 | Provayder o‘zining nostandart sxema so‘rovlarini aniqlaganda ishlatiladi | Provayderga xos |
| adSchemaAsserts | 0 | Katalogda aniqlangan tasdiqlarni (assertions) qaytaradi | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME |
| adSchemaCatalogs | 1 | DBMS’dan murojaat qilish mumkin bo‘lgan kataloglar bilan bog‘liq fizik atributlarni qaytaradi | CATALOG_NAME |
| adSchemaCharacterSets | 2 | Katalogda aniqlangan belgilar to‘plamlarini (character sets) qaytaradi | CHARACTER_SET_CATALOG CHARACTER_SET_SCHEMA CHARACTER_SET_NAME |
| adSchemaCollations | 3 | Katalogda aniqlangan belgilarni saralash qoidalarini (collations) qaytaradi | COLLATION_CATALOG COLLATION_SCHEMA COLLATION_NAME |
| adSchemaColumns | 4 | Katalogda aniqlangan jadvallarning ustunlarini qaytaradi | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
| adSchemaCheckConstraints | 5 | Katalogda aniqlangan tekshiruv cheklovlarini (check constraints) qaytaradi | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME |
| adSchemaConstraintColumnUsage | 6 | Katalogda aniqlangan havola cheklovlari (referential constraints), noyoblik cheklovlari, tekshiruv cheklovlari va tasdiqlar ishlatadigan ustunlarni qaytaradi | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
| adSchemaConstraintTableUsage | 7 | Katalogda aniqlangan havola cheklovlari, noyoblik cheklovlari, tekshiruv cheklovlari va tasdiqlar ishlatadigan jadvallarni qaytaradi | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME |
| adSchemaKeyColumnUsage | 8 | Katalogda aniqlangan, kalit sifatida cheklangan ustunlarni qaytaradi | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
| AdSchemaReferentialConstraints | 9 | Katalogda aniqlangan havola cheklovlarini (referential constraints) qaytaradi | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME |
| adSchemaTableConstraints | 10 | Katalogda aniqlangan jadval cheklovlarini qaytaradi | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE |
| adSchemaColumnsDomainUsage | 11 | Katalogda aniqlangan va katalogdagi domenga bog‘liq bo‘lgan ustunlarni qaytaradi | DOMAIN_CATALOG DOMAIN_SCHEMA DOMAIN_NAME COLUMN_NAME |
| adSchemaIndexes | 12 | Katalogda aniqlangan indekslarni qaytaradi | TABLE_CATALOG TABLE_SCHEMA INDEX_NAME TYPE TABLE_NAME |
| adSchemaColumnPrivileges | 13 | Katalogda aniqlangan jadvallar ustunlariga berilgan imtiyozlarni (privileges) qaytaradi | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME GRANTOR GRANTEE |
| adSchemaTablePrivileges | 14 | Katalogda aniqlangan jadvallarga berilgan imtiyozlarni qaytaradi | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME GRANTOR GRANTEE |
| adSchemaUsagePrivileges | 15 | Katalogda aniqlangan obyektlarga berilgan USAGE imtiyozlarini qaytaradi | OBJECT_CATALOG OBJECT_SCHEMA OBJECT_NAME OBJECT_TYPE GRANTOR GRANTEE |
| adSchemaProcedures | 16 | Katalogda aniqlangan protseduralarni qaytaradi | PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME PROCEDURE_TYPE |
| adSchemaSchemata | 17 | Sxemalarni (ma’lumotlar bazasi obyektlarini) qaytaradi | CATALOG_NAME SCHEMA_NAME SCHEMA_OWNER |
| adSchemaSQLLanguages | 18 | Katalogda aniqlangan ma’lumotlarni qayta ishlovchi SQL realizatsiyasi qo‘llab-quvvatlaydigan muvofiqlik darajalari, parametrlar va dialektlarni qaytaradi. | Yo‘q |
| adSchemaStatistics | 19 | Katalogda aniqlangan statistikani qaytaradi | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME |
| adSchemaTables | 20 | Katalogda aniqlangan va murojaat qilish mumkin bo‘lgan jadvallarni qaytaradi | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE |
| adSchemaTranslations | 21 | Katalogda aniqlangan va murojaat qilish mumkin bo‘lgan belgi o‘girishlarini (translations) qaytaradi | TRANSLATION_CATALOG TRANSLATION_SCHEMA TRANSLATION_NAME |
| adSchemaProviderTypes | 22 | Ma’lumotlar provayderi qo‘llab-quvvatlaydigan ma’lumot tiplarini qaytaradi | DATA_TYPE BEST_MATCH |
| adSchemaViews | 23 | Katalogda aniqlangan va murojaat qilish mumkin bo‘lgan ko‘rinishlarni (views) qaytaradi | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME |
| adSchemaViewColumnUsage | 24 | Ko‘rinishlar (views) bog‘liq bo‘lgan ustunlarni qaytaradi | VIEW_CATALOG VIEW_SCHEMA VIEW_NAME |
| adSchemaViewTableUsage | 25 | Ko‘rinishlar (views) bog‘liq bo‘lgan jadvallarni qaytaradi | VIEW_CATALOG VIEW_SCHEMA VIEW_NAME |
| adSchemaProcedureParameters | 26 | Protseduralarning parametrlari va qaytarish kodlari haqidagi ma’lumotlarni qaytaradi | PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME PARAMETER_NAME |
| adSchemaForeignKeys | 27 | Katalogda aniqlangan tashqi kalit (foreign key) ustunlarini qaytaradi | PK_TABLE_CATALOG PK_TABLE_SCHEMA PK_TABLE_NAME FK_TABLE_CATALOG FK_TABLE_SCHEMA FK_TABLE_NAME |
| adSchemaPrimaryKeys | 28 | Katalogda aniqlangan birlamchi kalit (primary key) ustunlarini qaytaradi | PK_TABLE_CATALOG PK_TABLE_SCHEMA PK_TABLE_NAME |
| adSchemaProcedureColumns | 29 | Protseduralar qaytaradigan qatorlar to‘plamlari (rowsets) ustunlari haqidagi ma’lumotlarni qaytaradi | PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME COLUMN_NAME |
| adSchemaDBInfoKeywords | 30 | Provayderga xos kalit so‘zlar ro‘yxatini qaytaradi | Yo‘q |
| adSchemaDBInfoLiterals | 31 | Matnli buyruqlarda ishlatiladigan, provayderga xos literallar ro‘yxatini qaytaradi | Yo‘q |
| adSchemaCubes | 32 | Sxemadagi mavjud kublar (cubes) haqidagi ma’lumotlarni qaytaradi | CATALOG_NAME SCHEMA_NAME CUBE_NAME |
| adSchemaDimensions | 33 | Berilgan kubdagi o‘lchovlar (dimensions) haqidagi ma’lumotlarni qaytaradi | CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_NAME DIMENSION_UNIQUE_NAME |
| adSchemaHierarchies | 34 | O‘lchovdagi mavjud iyerarxiyalar haqidagi ma’lumotlarni qaytaradi | CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_NAME HIERARCHY_UNIQUE_NAME |
| adSchemaLevels | 35 | O‘lchovdagi mavjud darajalar haqidagi ma’lumotlarni qaytaradi | CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_NAME LEVEL_UNIQUE_NAME |
| adSchemaMeasures | 36 | Mavjud ko‘rsatkichlar (measures) haqidagi ma’lumotlarni qaytaradi | CATALOG_NAME SCHEMA_NAME CUBE_NAME MEASURE_NAME MEASURE_UNIQUE_NAME |
| adSchemaProperties | 37 | O‘lchovning har bir darajasi uchun mavjud xususiyatlar haqidagi ma’lumotlarni qaytaradi | CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_UNIQUE_NAME MEMBER_UNIQUE_NAME PROPERTY_TYPE PROPERTY_NAME |
| adSchemaMembers | 38 | Mavjud a’zolar (members) haqidagi ma’lumotlarni qaytaradi | CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_UNIQUE_NAME LEVEL_NUMBER MEMBER_NAME MEMBER_UNIQUE_NAME MEMBER_CAPTION MEMBER_TYPE TREE OPERATOR |
| adSchemaTrustees | 39 | Kelajakda foydalanish uchun | Yo‘q |
❮ Connection obyektining to‘liq ma’lumotnomasi
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!