sql - How to find list of all tables in Access Database matching certain format in Delphi -


I need to compute a list of table names in a given database (MDB format), in which there are some formats (For example, the date time zone is "Date applied") How can I do this?

Note: I am using Delphi 7, ADO components, to join the Microsoft JAT 4.0 MDB TypeDatabase.

A schema may be appropriate:

 set  rs = Cn.OpenSchema (adSchemaColumns, _Aray (empty, empty, empty, SelectFieldName))  

where adSchemaColumn = 4
RS is a RecordSet object - CN connection object
SelectFieldName this status The name of the column is "Applied Date".

There are constraints for this schema:

  TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME  

The columns (fields) are back:

  TABLE_CATALOG TABLE_SCHEMA TABLE_NAME column COLUMN_GUID COLUMN_PROPID ORDINAL_POSITION COLUMN_HASDEFAULT COLUMN_DEFAULT COLUMN_FLAGS IS_NULLABLE DATA_TYPE TYPE_GUID CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_CATALOG CHARACTER_SET_SCHEMA CHARACTER_SET_NAME COLLATION_ CATALOG COLLATION_SCHEMA COLLATION_NAME DOMAIN_CATALOG DOMAIN_SCHEMA DOMAIN_NAME DESCRIPTION  

- [a Obtaining schema information from database] (


Comments

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

php - Multiple Select with Explode: only returns the word "Array" -

php - jQuery AJAX Post not working -