The DDEX Provider for Adaptive Server exposes Adaptive Server objects, which can be viewed and accessed in the Visual Studio Server Explorer.
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 |