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

(c) 1998 Microsoft Corporation. All rights reserved.

󴣨ѳ̷sΨ䥦TAɨ Microsoft ADO Extensions for DDL 
and Security (ADOX) UC

--------
e
--------

1. ~
   
2. \
   
3. ޳N`Nƶ

4. wDBMѨMk

----------------------
1. ~
----------------------

Microsoft ActiveX Data Objects Extensions for Data Definition Language and
Security (ADOX) O ADO M{]pҦCADOX ]AΩإ߻Pקﵲc
ԭz (schema) HΦwʪC]OH󬰰¦cԭzkAz
iHgbPƨӷ檺{XA׭ͽXyktʡC

---------------
2. \
---------------

ADOX O ADO ֤ߪft{wC|B~AΨӫإߡBקMR
cԭzAҦpM{ǡC

------------------
3. ޳N`Nƶ
------------------

3.1 n/ΪBޥHθƦݩ

zƴѪ (provider) iH䴩ҦBޥHθƦ檫ݩʡC
pGѪ̤䴩ݩʳ]wFYӭȡAN|oͿ~CbsB
ީθƦ譱AQ[춰XɴN|oͿ~Cܩ{
Ab]wݩʪɭԷ|oͿ~C

إߪBީθƦ檫󪺮ɭԡAΩݩʪAw]ȵLkO
zѪ̷|䴩ݩʡCpݴѪ̤䴩ݩʸԲӸTAаѾ\z
Ѫ̤UC

3.2 N ADOX P Microsoft OLE DB Providers @_ϥ

̷ӱz OLE DB ƴѪ̤PA䴩Sw ADOX \CMicrosoft OLE DB 
Provider for the Microsoft Jet Database Engine 䴩 ADOXCܩ Microsoft
SQL Server OLE DB ProviderBMicrosoft OLE DB Provider for ODBC 
Microsoft OLE DB Provider for Oracle 譱AаѾ\UCC䥦 Microsoft
OLE DB Ѫ̤䴩 ADOXC

Microsoft SQL Server OLE DB Provider

FbҦC~AiH䴩Ҧ ADOX BXBݩʩMkG

OGCreate kC
G{檺ݩʬOŪ (s檺ݩʥiHOŪ/g)C
˵G䴩C
{ǡGAppend kBDelete kBCommand ݩʡC
GAppend kBDelete kC
ϥΪ̡G䴩C
sաG䴩C

Microsoft OLE DB Provider for ODBC

FbҦC~AiH䴩Ҧ ADOX BXBݩʩMkG

OGCreate kC
GAppend kBDelete kC{檺ݩʬOŪ 
(s檺ݩʥiHOŪ/g)C
˵GAppend kBDelete kBCommand ݩʡC
{ǡGAppend kBDelete kBCommand ݩʡC
ޡGAppend kBDelete kC
GAppend kBDelete kC
ϥΪ̡G䴩C
sաG䴩C


Microsoft OLE DB Provider for Oracle

FbҦC~AiH䴩Ҧ ADOX BXBݩʩMkG

OGCreate kC
GAppend kBDelete kC{檺ݩʬOŪ 
(s檺ݩʥiHOŪ/g)C
˵GAppend kBDelete kBCommand ݩʡC
{ǡGAppend kBDelete kBCommand ݩʡC
ޡGAppend kBDelete kC
GAppend kBDelete kC
ϥΪ̡G䴩C
sաG䴩C


-----------------
4. wDBMѨMk
-----------------

UCO ADOX wDMG

4.1 DateCreated/DateModified ݩʻݭn Refresh

bs[󤤡ADateCreated M DateModified ݩʬO NULLC
[s View  Procedure ɡAIs View  Procedure X 
Refresh kAHKo DateCreated M DateModified ݩʪȡC

4.2 Index S ParentCatalog ݩ

b ADOX AParentCatalog Q~C Index ݩʡCParentCatalog
ڤWOuO Column M Table ݩʡC

4.3 adAccessRevoke N SetPermissions  Rights Ѽ

Is Group  User  SetPermissions kɡAN Actions ѼƳ]
adAccessRevoke |N Rights ѼƪȡCpGQ Rights ѼƤ
wvͮġAФnN Actions ] adAccessRevokeC

4.4 Append k RelatedColumn Ѽ (Keys X)

Key X Appen kӥ]t@ӿΪ 4 ӰѼ - RelatedColumnC
syk:

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

RelatedColumn ѼƬOΪCRelatedColumn O@ String ȡAiHw
foreign key W١CRelatedTable ѼƥiH Column  Name ݩʩʡC

4.5 IndexNulls ݩʪ adIndexNullsAllow Enum 

Index  IndexNulls ݩʤӦbĭȪ]t@Φh Enum `:

adIndexNullsAllow     ޤ\쬰 Null ɿJơCYb
J Null ȡAJƷ|QޡC 

