---------------------------------------------------------
Microsoft ActiveX(R) Data Objects Extensions for DDL and Security
README
---------------------------------------------------------

1998 (C) Copyright Microsoft Corporation. All rights reserved.

̃t@Cɂ́AhLgɋLڂȂŐV̏񂨂ѕ⑫Iȏ񂪋LqĂ܂B

----
ڎ
----

1. i

2. V@\

3. ZpIȏ

4. oOAAύXAэŐṼhLg

-----------
1. i
-----------

Microsoft(R) ActiveX(R) Data Objects Extensions for Data Definition Language and Security (ADOX) ́AADO ̃IuWFNgуvO~O f̊g@\łBADOX ́AZLeBɉAXL[}̍쐬яĈ߂̃IuWFNg܂݂܂BIuWFNg x[XŃXL[}ɃAv[`邽߁AlCeBuȍ\̑ɂ炸A܂܂ȃf[^ \[Xɑ΂ďsR[hLqł܂B

---------
2. V@\
---------

ADOX ́ARA ADO IuWFNgɕt郉CułB́Ae[uvV[WȂǂ̃XL[} IuWFNg̍쐬ACAэ폜̂߂̒ǉIuWFNgJ܂B͂܂A[U[уO[vێAIuWFNgɑ΂ANZX^AĎ߂̃ZLeB IuWFNg܂݂܂B

---------------
3. ZpIȏ
---------------

3.1 K{邢͏ȗ\ȁATableAIndexAColumn IuWFNg̃vpeB

gpf[^ voC_ATableAIndexAColumn IuWFNĝׂẴvpeBT|[g킯ł͂܂BvoC_T|[gĂȂvpeBɒlݒ肷ƁAG[܂BV TableAIndexAColumn IuWFNgł́AIuWFNgRNVɒǉꂽƂɃG[܂B̃IuWFNgł́AvpeBݒ肳ꂽƂɃG[܂B

TableAIndexAColumn IuWFNg쐬ƂAgpvoC_ɂăT|[gvpeBɁAȗ\ȃvpeB̓K؂ȃftHgl邩Ƃ͕ۏ؂܂BgpvoC_T|[gvpeB̏ڍׂɂẮAvoC_̃hLgQƂĂB

3.2 Microsoft OLE DB Provider ł ADOX ̎gp

ADOX ̋@\T|[gĂȂƂ炩Ȃ̂́Agp OLE DB voC_Ɉˑ܂BADOX ́AMicrosoft Jet f[^x[X GW Microsoft OLE DB Provider SɃT|[g܂BMicrosoft SQL Server OLE DB ProviderAMicrosoft OLE DB Provider for ODBCAMicrosoft OLE DB Provider for Oracle ɂĂ͌q܂BADOX ́ÂׂĂ Microsoft OLE DB provider ɃT|[g킯ł͂܂B

Microsoft SQL Server OLE DB Provider

Ɏ̈ȊÓAׂĂ ADOX ̃IuWFNgARNVAvpeBA\bhT|[g܂B

Catalog: Create \bhB
Tables: ̃e[ũvpeB́Aǂݍݐpł (Ve[ũvpeB͓ǂݏ\ł)B
Views: T|[g܂B
Procedures: Append \bhADelete \bhACommand vpeBB
INdex: Append \bhADelete \bh
Keys: Append \bhADelete \bhB
Users: T|[g܂B
Groups: T|[g܂B

Microsoft OLE DB Provider for ODBC

Ɏ̈ȊÓAׂĂ ADOX ̃IuWFNgARNVAvpeBA\bhT|[g܂B

Catalog: Create \bhB
Tables: Append \bhADelete \bhB
Columns: Append \bhADelete \bh
Views: T|[g܂B
Procedures: Append \bhADelete \bhACommand vpeBB
Indexes: Append \bhADelete \bhB
Keys: T|[g܂B
Users: T|[g܂B
Groups: T|[g܂B

Microsoft OLE DB Provider for Oracle

Ɏ̈ȊÓAׂĂ ADOX ̃IuWFNgARNVAvpeBA\bhT|[g܂B

Catalog: Create \bhB
Tables: Append \bhADelete \bhB
Columns: Append \bhADelete \bh
Views: Append \bhADelete \bhACommand vpeBB
Procedures: Append \bhADelete \bhACommand vpeBB
Indexes: Append \bhADelete \bhB
Keys: T|[g܂B
Users: T|[g܂B
Groups: T|[g܂B

-----------------------------------------------------
4. oOAAύXAэŐṼhLg
-----------------------------------------------------

ɁAݒmĂ ADOX ̐܂B

4.1 DateCreated/DateModified vpeBɂ Refresh \bhKv

DateCreated  DateModified vpeB́AVKɒǉꂽIuWFNgɑ΂Ă Null lԂ܂BVK̃r[邢̓vV[WɒǉADateCreated  DateModified vpeB̒l擾ɂ́AViews ܂ Procedures RNV Refresh \bhĂяoȂ΂Ȃ܂B

4.2 Index IuWFNg ParentCatalog vpeB݂͑Ȃ

ADOX wvɂ́AIndex IuWFNg̃vpeBƂ ParentCatalog vpeBXgĂ܂A͐܂BParentCatalog vpeB́Aۂɂ Column  Table IuWFNg̃vpeBłB

4.3 adAccessRevoke 萔 SetPermissions \bh Rights p[^㏑

Group ܂ User RNV SetPermissions \bhĂяoƂAActions p[^ adAccessRevoke 萔ݒ肷ƁARights p[^ׂ̂Ă̐ݒ肪㏑܂BRights p[^Ɏw肵ʂ悤ɂɂ́AActions p[^ adAccessRevoke 萔ݒ肵ȂłB

4.4 Append \bh (Keys RNV)  RelatedColumn p[^

Keys RNV Append \bh̐ɂuAppend \bh (Keys)vɂ́A4 ڂ̃p[^ (RelatedColumn) KvłB͎̂悤ɂȂĂ܂ :

Keys.Append Key [, KeyType] [, Column] [, RelatedTable] [, RelatedColumn]

RelatedColumn p[^́AOL[Ɋ֘Atꂽ̖Olł (̃p[^͏ȗ\ł)BRelatedTable p[^́AColumn IuWFNg Name vpeB̒lƑΉ邱Ƃł܂B

4.5 IndexNulls vpeB adIndexNullsAllow

Index IuWFNg̐ɂuIndexNulls vpeBv̒萔\ɂ́A 1 ̗񋓌^ (Enum) 萔܂ :

adIndexNullsAllow     CfbNX́AL[ Null l̃Gg܂BL[̃Gg Null l̏ꍇAGgCfbNXɒǉ܂B
