Supported Adaptive Server objects

The DDEX Provider for Adaptive Server exposes Adaptive Server objects, which can be viewed and accessed in the Visual Studio Server Explorer.

Table 7: Supported Adaptive Server Objects

Database Object

Properties

Check Constraint

Name, Catalog, Schema, Table, Constraint Column, Constraint Type

Column of Web Service as Table

Name, Catalog, Schema, Table, Default Value, Is Nullable, Ordinal, Length, Precision, Scale, System Type

Database

Name, Create Date, Dump Date

Datatype

Name

Default

Name, Catalog, Schema

Foreign Key

Name, Catalog, Schema, Table, Referenced Table, Referenced Table Catalog, Referenced Table Column, Referenced Table Schema

Index

Name, Catalog, Schema, Table, Referred Column

Instead-of Trigger

Name, Catalog, Schema, View

Primary Key

Name, Catalog, Schema, Table, Referred Column

Proxy Table

Name, Catalog, Schema

Proxy Table Column

Name, Catalog, Schema, Table, Default Value, Is Nullable, Ordinal, Length, Precision, Scale, System Type

Rule

Name, Catalog, Schema

Schema

Name

Stored Procedure

Name, Catalog, Schema

Stored Procedure Parameter

Name, Catalog, Schema, Stored Procedure, Is Output, Ordinal, Length, Precision, Scale, System Type

Table

Name, Catalog, Schema, Type

Table Column

Name, Catalog, Schema, Table, Default Value, Is Nullable, Ordinal, Length, Precision, Scale, System Type

Trigger

Name, Catalog, Schema, Table

Unique Constraint

Name, Catalog, Schema, Table, Referred Column

User-defined Function

Name, Catalog, Schema

User-defined Function Parameter

Name, Catalog, Schema, User-defined Function, Is Output, Ordinal, Length, Precision, Scale, System Type

User-defined Type

Name, Catalog, Schema

View

Name, Catalog, Schema

View Column

Name, Catalog, Schema, View, Default Value, Is Nullable, Ordinal, Length, Precision, Scale, System Type

Web Services as Table

Name, Catalog, Schema, Method, Timeout, WSDL URI