I have the following that I can pull from the schema:
rst.Open CurrentProject.Connection.OpenSchema(adSchemaColumns, Array(Empty, Empty, strTableName, Empty))
gets me
0: TABLE_CATALOG =
1: TABLE_SCHEMA =
2: TABLE_NAME = Log
3: COLUMN_NAME = LogID
4: COLUMN_GUID =
5: COLUMN_PROPID =
6: ORDINAL_POSITION = 1
7: COLUMN_HASDEFAULT = False
8: COLUMN_DEFAULT =
9: COLUMN_FLAGS = 90
10: IS_NULLABLE = False
11: DATA_TYPE = 3
12: TYPE_GUID =
13: CHARACTER_MAXIMUM_LENGTH =
14: CHARACTER_OCTET_LENGTH =
15: NUMERIC_PRECISION = 10
16: NUMERIC_SCALE =
17: DATETIME_PRECISION =
18: CHARACTER_SET_CATALOG =
19: CHARACTER_SET_SCHEMA =
20: CHARACTER_SET_NAME =
21: COLLATION_CATALOG =
22: COLLATION_SCHEMA =
23: COLLATION_NAME =
24: DOMAIN_CATALOG =
25: DOMAIN_SCHEMA =
26: DOMAIN_NAME =
27: DESCRIPTION =
How do I know if a column is a primary key? I can't seem to find it...
Randall Vollen
National City Bank Corp.
rst.Open CurrentProject.Connection.OpenSchema(adSchemaColumns, Array(Empty, Empty, strTableName, Empty))
gets me
0: TABLE_CATALOG =
1: TABLE_SCHEMA =
2: TABLE_NAME = Log
3: COLUMN_NAME = LogID
4: COLUMN_GUID =
5: COLUMN_PROPID =
6: ORDINAL_POSITION = 1
7: COLUMN_HASDEFAULT = False
8: COLUMN_DEFAULT =
9: COLUMN_FLAGS = 90
10: IS_NULLABLE = False
11: DATA_TYPE = 3
12: TYPE_GUID =
13: CHARACTER_MAXIMUM_LENGTH =
14: CHARACTER_OCTET_LENGTH =
15: NUMERIC_PRECISION = 10
16: NUMERIC_SCALE =
17: DATETIME_PRECISION =
18: CHARACTER_SET_CATALOG =
19: CHARACTER_SET_SCHEMA =
20: CHARACTER_SET_NAME =
21: COLLATION_CATALOG =
22: COLLATION_SCHEMA =
23: COLLATION_NAME =
24: DOMAIN_CATALOG =
25: DOMAIN_SCHEMA =
26: DOMAIN_NAME =
27: DESCRIPTION =
How do I know if a column is a primary key? I can't seem to find it...
Randall Vollen
National City Bank Corp.