OpenSchema SchemaEnum

最新推荐文章于 2020-12-10 08:40:21 发布
最新推荐文章于 2020-12-10 08:40:21 发布
阅读量1.8k 收藏
点赞数
分类专栏： ASP 文章标签： constraints schema table hierarchy character collation
ConstantValueDescriptionConstraint Columns
adSchemaAsserts0Returns the assertions defined in the catalog that are owned by a given user.

(ASSERTIONS Rowset)

CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
adSchemaCatalogs1Returns the physical attributes associated with catalogs accessible from the DBMS.

(CATALOGS Rowset)

CATALOG_NAME
adSchemaCharacterSets2Returns the character sets defined in the catalog that are accessible to a given user.

(CHARACTER_SETS Rowset)

CHARACTER_SET_CATALOG
CHARACTER_SET_SCHEMA
CHARACTER_SET_NAME
adSchemaCheckConstraints5Returns the check constraints defined in the catalog that are owned by a given user.

(CHECK_CONSTRAINTS Rowset)

CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
adSchemaCollations3Returns the character collations defined in the catalog that are accessible to a given user.

(COLLATIONS Rowset)

COLLATION_CATALOG
COLLATION_SCHEMA
COLLATION_NAME
adSchemaColumnPrivileges13Returns the privileges on columns of tables defined in the catalog that are available to, or granted by, a given user.

(COLUMN_PRIVILEGES Rowset)

TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
GRANTOR
GRANTEE
adSchemaColumns4Returns the columns of tables (including views) defined in the catalog that are accessible to a given user.

(COLUMNS Rowset)

TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
adSchemaColumnsDomainUsage11Returns the columns defined in the catalog that are dependent on a domain defined in the catalog and owned by a given user.

(COLUMN_DOMAIN_USAGE Rowset)

DOMAIN_CATALOG
DOMAIN_SCHEMA
DOMAIN_NAME
COLUMN_NAME
adSchemaConstraintColumnUsage6Returns the columns used by referential constraints, unique constraints, check constraints, and assertions, defined in the catalog and owned by a given user.

(CONSTRAINT_COLUMN_USAGE Rowset)

TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
adSchemaConstraintTableUsage7Returns the tables that are used by referential constraints, unique constraints, check constraints, and assertions defined in the catalog and owned by a given user.

(CONSTRAINT_TABLE_USAGE Rowset)

TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
adSchemaCubes32Returns information about the available cubes in a schema (or the catalog, if the provider does not support schemas).

(CUBES Rowset*)

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
adSchemaDBInfoKeywords30Returns a list of provider-specific keywords.

(IDBInfo::GetKeywords*)

<None>
adSchemaDBInfoLiterals31Returns a list of provider-specific literals used in text commands.

(IDBInfo::GetLiteralInfo*)

<None>
adSchemaDimensions33Returns information about the dimensions in a given cube. It has one row for each dimension.

(DIMENSIONS Rowset*)

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
DIMENSION_NAME
DIMENSION_UNIQUE_NAME
adSchemaForeignKeys27Returns the foreign key columns defined in the catalog by a given user.

(FOREIGN_KEYS Rowset)

PK_TABLE_CATALOG
PK_TABLE_SCHEMA
PK_TABLE_NAME
FK_TABLE_CATALOG
FK_TABLE_SCHEMA
FK_TABLE_NAME
adSchemaHierarchies34Returns information about the hierarchies available in a dimension.

(HIERARCHIES Rowset*)

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
DIMENSION_UNIQUE_NAME
HIERARCHY_NAME
HIERARCHY_UNIQUE_NAME
adSchemaIndexes12Returns the indexes defined in the catalog that are owned by a given user.

(INDEXES Rowset)

TABLE_CATALOG
TABLE_SCHEMA
INDEX_NAME
TYPE
TABLE_NAME
adSchemaKeyColumnUsage8Returns the columns defined in the catalog that are constrained as keys by a given user.

(KEY_COLUMN_USAGE Rowset)

CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
adSchemaLevels35Returns information about the levels available in a dimension.

(LEVELS Rowset*)

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
DIMENSION_UNIQUE_NAME
HIERARCHY_UNIQUE_NAME
LEVEL_NAME
LEVEL_UNIQUE_NAME
adSchemaMeasures36Returns information about the available measures.

(MEASURES Rowset*)

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
MEASURE_NAME
MEASURE_UNIQUE_NAME
adSchemaMembers38Returns information about the available members.

(MEMBERS Rowset*)

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 (For more information, see the OLE DB for OLAP documentation.)
adSchemaPrimaryKeys28Returns the primary key columns defined in the catalog by a given user.

(PRIMARY_KEYS Rowset)

PK_TABLE_CATALOG
PK_TABLE_SCHEMA
PK_TABLE_NAME
adSchemaProcedureColumns29Returns information about the columns of rowsets returned by procedures.

(PROCEDURE_COLUMNS Rowset)

PROCEDURE_CATALOG
PROCEDURE_SCHEMA
PROCEDURE_NAME
COLUMN_NAME
adSchemaProcedureParameters26Returns information about the parameters and return codes of procedures.

(PROCEDURE_PARAMETERS Rowset)

PROCEDURE_CATALOG
PROCEDURE_SCHEMA
PROCEDURE_NAME
PARAMETER_NAME
adSchemaProcedures16Returns the procedures defined in the catalog that are owned by a given user.

(PROCEDURES Rowset)

PROCEDURE_CATALOG
PROCEDURE_SCHEMA
PROCEDURE_NAME
PROCEDURE_TYPE
adSchemaProperties37Returns information about the available properties for each level of the dimension.

(PROPERTIES Rowset*)

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
DIMENSION_UNIQUE_NAME
HIERARCHY_UNIQUE_NAME
LEVEL_UNIQUE_NAME
MEMBER_UNIQUE_NAME
PROPERTY_TYPE
PROPERTY_NAME
adSchemaProviderSpecific-1Used if the provider defines its own nonstandard schema queries.<Provider specific>
adSchemaProviderTypes22Returns the (base) data types supported by the data provider.

(PROVIDER_TYPES Rowset)

DATA_TYPE
BEST_MATCH
AdSchemaReferentialConstraints9Returns the referential constraints defined in the catalog that are owned by a given user.

(REFERENTIAL_CONSTRAINTS Rowset)

CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
adSchemaSchemata17Returns the schemas (database objects) that are owned by a given user.

(SCHEMATA Rowset)

CATALOG_NAME
SCHEMA_NAME
SCHEMA_OWNER
adSchemaSQLLanguages18Returns the conformance levels, options, and dialects supported by the SQL-implementation processing data defined in the catalog.

(SQL_LANGUAGES Rowset)

<None>
adSchemaStatistics19Returns the statistics defined in the catalog that are owned by a given user.

(STATISTICS Rowset)

TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
adSchemaTableConstraints10Returns the table constraints defined in the catalog that are owned by a given user.

(TABLE_CONSTRAINTS Rowset)

CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
CONSTRAINT_TYPE
adSchemaTablePrivileges14Returns the privileges on tables defined in the catalog that are available to, or granted by, a given user.

(TABLE_PRIVILEGES Rowset)

TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
GRANTOR
GRANTEE
adSchemaTables20Returns the tables (including views) defined in the catalog that are accessible to a given user.

(TABLES Rowset)

TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
TABLE_TYPE
adSchemaTranslations21Returns the character translations defined in the catalog that are accessible to a given user.

(TRANSLATIONS Rowset)

TRANSLATION_CATALOG
TRANSLATION_SCHEMA
TRANSLATION_NAME
adSchemaTrustees39Reserved for future use. 
adSchemaUsagePrivileges15Returns the USAGE privileges on objects defined in the catalog that are available to, or granted by, a given user.

(USAGE_PRIVILEGES Rowset)

OBJECT_CATALOG
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_TYPE
GRANTOR
GRANTEE
adSchemaViewColumnUsage24Returns the columns on which viewed tables, defined in the catalog and owned by a given user, are dependent.

(VIEW_COLUMN_USAGE Rowset)

VIEW_CATALOG
VIEW_SCHEMA
VIEW_NAME
adSchemaViews23Returns the views defined in the catalog that are accessible to a given user.

(VIEWS Rowset)

TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
adSchemaViewTableUsage25Returns the tables on which viewed tables, defined in the catalog and owned by a given user, are dependent.

(VIEW_TABLE_USAGE Rowset)

VIEW_CATALOG
VIEW_SCHEMA
VIEW_NAME
Aricc
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
OpenSchema 方法
weixin_33802505的博客
11-17 302
OpenSchema 方法 从提供者获取数据库模式信息。 语法 Set recordset = connection.OpenSchema (QueryType, Criteria, SchemaID) 返回值 返回包含模式信息的 Recordset 对象。Recordset 将以只读、静态游标打开。 参数 QueryType   所要运行的模式查询类型，可以为下列任意常量。 Cr...
ADO的OpenSchema
DotNetFirst的专栏
07-21 1251
  Dim oConn,oRS,sConn  Const adUseClient = 3  Const adSchemaTables = 20  Set oConn = Server.CreateObject("ADODB.Connection")  sConn = "DBQ="+server.mappath("chinawuyishan.mdb")+";DRIVER={Microsoft
ADO OpenSchema 方法
fivedoumi的专栏
11-22 1631
ADO OpenSchema 方法 The OpenSchema method returns a Recordset object with schema information from the provider about the data source. For example, schema information can include the names o
VBA-判断数据表是否存在（openschema）
oyq的博客
07-28 4562
1.首先我们可以学习一下错误捕捉，当数据表不存在的时候，删除数据表就会出现错误，此时就会有错误记录，我们就可以利用本地窗口看到错误的信息 Sub 错误捕捉() Dim mydata As String Dim mytable As String Dim con As New ADODB.Connection mydata = ThisWorkbook.Path ...
OpenSchema 方法详解
Aricc的专栏
04-16 3732
OpenSchema 方法从提供者获取数据库模式信息。语法Set recordset = connection.OpenSchema (QueryType, Criteria, SchemaID)返回值返回包含模式信息的 Recordset 对象。Recordset 将以只读、静态游标打开。参数QueryType   所要运行的模式查询类型，可以为下列任意常量。Criteria   可选。每个 Q
openschema:http 镜像
06-26
开放式架构OpenSchema 提供了（McKeown 1985）文档结构模式的声明性实现。 Schemata 是一种广泛使用的战略生成解决方案，针对经过一段时间结构已经固定的文本（因此没有推理过程可以重新创建这种结构）。 有关更多...
guidance-appinsights-openschema:在OpenSchema中使用Application Insights
05-17
服务平台作者日期应用洞察网络米奇图布2017年5月使用OpenSchema的Application Insights Analytics 此示例说明如何使用Application Insights Client SDK管道，将Application Insights Analytics与OpenSchema和第三方...
OpenSchema:用于自然语言生成的文档结构模式-开源
04-29
OpenSchema 是一个开源项目，专注于自然语言生成（NLG）领域的文档结构模式。这个项目提供了一个Java实现，允许开发者创建和使用文档结构模式来指导NLG系统如何将数据转化为人类可读的语言。文档结构模式（Schemata...
利用ADO获取Access数据库中的表名
05-29
在IT领域，数据库管理是至关重要的，特别是在关系型数据库中，如Microsoft Access。本文将深入探讨如何使用ActiveX Data Objects（ADO）来获取Access数据库中的表名，并将这些表名展示到用户界面组件，如ListBox和...
检查access数据库中是否存在某个名字的表的asp代码
10-29
当你提供一个特定的`SchemaEnum`常量作为参数时，`OpenSchema`将返回一个`Adodb.Recordset`，其中包含数据库的相关元数据。在ASP中，你可以通过遍历这个Recordset来获取所需信息。 在给定的代码中，`adSchemaTables...
VC中使用ADO操作数据库的方法（比较详细）
白永辉的专栏
04-14 3103
参考：http://blog.csdn.net/augusdi/article/details/7005597，做了部分补充和删除 准备工作： (1)、引入ADO类 #import "c:\program files\common files\system\ado\msado15.dll"  no_namespace rename ("EOF", "adoEOF") (2)、初始化COM
查询用户所有信息后只需要两个字段的信息_Excel VBA+ADO+SQL入门教程023：OpenSchema获取表信息...
weixin_39958366的博客
12-10 341
点上方关注我们，每日1练，每天进步一点点1.我们在使用SQL语言对数据库数据进行查询之前，有时需要获取每张表的表名，甚至获取每张表每个字段的名称等；比如，当我们进行跨工作簿数据查询及汇总时，在不打开相关工作簿的情况下，如何快速遍历指定工作簿每个工作表的名称？——Connection对象的OpenSchema方法可以帮助我们解决此类问题；它可以从提供者获取数据库模式的信息，并返回一个只读...
xml-schema枚举-字符约束
以后的23,725天，每一天都是精彩的，现在做，一切还来的及，相信自己！
10-15 1721
枚举--> 案例：1 xml version="1.0"?> xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.w3school.com.cn" xmlns="http://www.w3school.com.cn" elementFormDefault="qualified"
ADO API 参考( ADO方法)之四
wybm的专栏
07-23 1872
Open 方法 (ADO Connection)打开到数据源的连接。语法connection.Open ConnectionString, UserID, Password, Options参数ConnectionString   可选，字符串，包含连接信息。参阅 ConnectionString 属性可获得有效设置的详细信息。UserID   可选，字符串，包含建立连接时
如何显示一个表的字段信息（ACCESS）
Aricc的专栏
04-16 1750
         tablename=trim(tablename)   const adSchemaColumns=4   set rs=Conn.openSchema(adSchemaColumns,Array(empty, empty,tablename,empty))   rs.movefirst   %>                                          
vba获取access数据库的所有表名
最新发布
04-25
Set rs = cnn.OpenSchema(adSchemaTables) Do While Not rs.EOF If rs("TABLE_TYPE").Value = "TABLE" Then Debug.Print rs("TABLE_NAME").Value End If rs.MoveNext Loop rs.Close Set rs = Nothing Set ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值