TADMetaInfoQuery.ObjectName Property

Gets / sets the name of object to get detailed information about it.

Group

Links

TADMetaInfoQuery Class, TADMetaInfoQuery Members, uADCompClient Namespace, Example, published, See Also

The ObjectName property value defines the database objects, for which will be returned detailed information. The meaning, optionality and usage of the catalog and schema names depends on MetaInfoKind:

MetaInfoKind	Meaning	Catalog and schema names
mkTableFields	Table name.	Applicable.
mkIndexes	Table name.	Applicable.
mkIndexFields	Index name.	--
mkPrimaryKey	Table name.	Applicable.
mkForeignKeys	Table name.	Applicable.
mkForeignKeyFields	Foreign key constraint name.	--
mkProcArgs	Stored procedure name.	Applicable, for non-packages stored procedures.

The ObjectName together with CatalogName and SchemaName may constitute the full object name. If current DBMS session may "see" few objects with the same name, but in different catalogs and/or schemas, then we strongly suggest to specify CatalogName and/or SchemaName property values to explicitly limit the list of objects.

If object name is case sensitive or contains special character, then it must be explicitly quoted.

Assignment to this property value closes dataset.

Syntax

property ObjectName: String;

Example

  // get the field list of Northwind.dbo.Employees table
  ADMetaInfoQuery1.CatalogName := 'Northwind';
  ADMetaInfoQuery1.SchemaName := 'dbo';
  ADMetaInfoQuery1.ObjectName := 'Employees';
  ADMetaInfoQuery1.MetaInfoKind := mkTableFields;
  ADMetaInfoQuery1.Open;

What do you think about this topic? Send feedback!