supports (Database Toolbox)

Detect if property is supported by database metadata object

Syntax

a = supports(dbmeta)
a = supports(dbmeta, 'property')
a.property

Description

a = supports(dbmeta) returns a structure of the properties of dbmeta, which was created using dmd, and the corresponding property values, 1 or 0, where 1 means the property is supported and 0 means the property is not supported.

a = supports(dbmeta, 'property') returns the value, 1 or 0, of property for dbmeta, which was created using dmd, where 1 means the property is supported and 0 means the property is not supported.

a.property returns the value of property, after you created a using supports.

There are dozens of properties for dbmeta. Examples include 'GroupBy' and 'StoredProcedures'.

Examples

Type

```
a = supports(dbmeta, 'GroupBy')
```

and MATLAB returns

```
a =
     1
```

indicating that the database supports the use of SQL group-by clauses.

To find the GroupBy value as well as values for all other properties, type

```
a = supports(dbmeta)
```

MATLAB returns a list of properties and their values. The GroupBy property is included in the list. You can also see its value by typing

```
a.GroupBy
```

to which MATLAB returns

```
a =
     1
```

See Also
database, dmd, get, ping

sql2native tableprivileges