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:
setrs = 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
Post a Comment