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

(c) 1998 Microsoft Corporation. All rights reserved.

  Microsoft ADO Extensions for DDL and Security(ADOX)   ֱٿ ٲ ̳ Ÿ   ֽϴ.

------

------

1. ǰ 
   
2. 
   
3.  

4. ˷ , Ѱ  

-------------
1. ǰ 
-------------

Microsoft ADOX ADO ü α׷  Ȯ Դϴ. ADOX ȻӸ ƴ϶ Ű     ü Ե˴ϴ. ̰ ü   Ű   ̹Ƿ   ̿ ұϰ پ    ϴ ڵ带 ۼ  ֽϴ.

-------------
2. 
-------------

ADOX ٽ ADO ü ڸ ̺귯Դϴ. ̰ ̺ ν  Ű ü ۼ,   ϱ  ߰ ü մϴ.  ڿ ׷ ϰ ü  ְų ϱ   ü ԵǾ ֽϴ. 

-------------
3.  
-------------

3.1 Table, Index  Column ʼ/ Ӽ

Table, Index  Column ü  Ӽ  ڰ ϴ  ƴմϴ. ڰ  ʴ Ӽ   ϸ  ߻մϴ. ο Table, Index Ǵ Column ü ÷ǿ ߰Ǹ  ߻մϴ.  ü Ӽ    ߻մϴ. 

Table, Index Ǵ Column     Ӽ   ⺻ ִ Ȯ  Ӽ ڰ ϴ ̶   ϴ. ڰ ϴ Ӽ  ڼ    Ͻʽÿ.

3.2 Microsoft OLE DB Provider ADOX 

ADOX  ɵ OLE DB  ڿ   ʽϴ. ADOX Microsoft OLE DB Provider for the Microsoft Jet Database Engine Ϻϰ ˴ϴ. Microsoft SQL Server OLE DB Provider, Microsoft OLE DB Provider for ODBC Ǵ Microsoft OLE DB Provider for Oracle  Ʒ Ͻʽÿ. ٸ Microsoft OLE DB Provider ADOX  ʽϴ.

Microsoft SQL Server OLE DB Provider

Ʒ  ͵   ADOX ü, ÷, Ӽ  ޼尡 ˴ϴ. 

Catalog: Create ޼
Tables:  ̺ Ӽ б Դϴ( ̺ Ӽ б/Ⱑ   ֽϴ).
Views:  
Procedures: Append ޼, Delete ޼, Command Ӽ
Keys: Append ޼, Delete ޼
Users:  
Groups:  

Microsoft OLE DB Provider for ODBC

Ʒ  ͵   ADOX ü, ÷, Ӽ  ޼尡 ˴ϴ. 

Catalog: Create ޼
Tables: Append ޼, Delete ޼.  ̺ Ӽ б Դϴ( ̺ Ӽ б/Ⱑ   ֽϴ).
Views: Append ޼, Delete ޼, Command Ӽ
Procedures: Append ޼, Delete ޼, Command Ӽ
Indexes: Append ޼, Delete ޼
Keys: Append ޼, Delete ޼
Users:  
Groups:  

Microsoft OLE DB Provider for Oracle

Ʒ  ͵   ADOX ü, ÷, Ӽ  ޼尡 ˴ϴ. 

Catalog: Create ޼
Tables: Append ޼, Delete ޼.  ̺ Ӽ б Դϴ( ̺ Ӽ б/Ⱑ   ֽϴ).
Views: Append ޼, Delete ޼, Command Ӽ
Procedures: Append ޼, Delete ޼, Command Ӽ
Indexes: Append ޼, Delete ޼
Keys: Append ޼, Delete ޼
Users:  
Groups:  


---------------------------
4. ˷ , Ѱ  
---------------------------

 ADOX ˷  Դϴ. 

4.1 DateCreated/DateModified Ӽ Refresh ޼尡 ʿմϴ.

DateCreated DateModified Ӽ  ߰ ü ؼ NULLԴϴ.  View Procedure ü ߰  DataCreated DataModified Ӽ   Views Procedures ÷ Refresh ޼带 ȣؾ մϴ.

4.2 Index ü ParentCatalog Ӽ ϴ.

ADOX 򸻿 ParentCatalog Index ü Ӽ ߸ Ǿ ֽϴ. ParentCatalog  Column Table ü  ӼԴϴ. 

4.3 adAccessRevoke SetPermission Rights Ű  մϴ.

׷̳  SetPermission ޼带 ȣ  Actions Ű  adAccessRevoke ϸ Rights Ű    õ˴ϴ. Rights Ű   Ǹ Ϸ Actions adAccessRevoke  ʽÿ.

4.4 Append ޼ RelatedColumn Ű (Keys ÷)

Keys ÷ Append ޼忡   RelatedColumn̶  ° Ű (ɼ)   ؾ մϴ. Ʈ   ϴ.

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

RelatedColumn Ű  ɼ̹Ƿ   ֽϴ. RelatedColumn ܷ Ű  õ  ̸ ϴ String Դϴ. RelatedTable Ű  Column ü Name Ӽ ġ  ֽϴ.

4.5 IndexNulls Ӽ adIndexNullsAllow Enum 

Index ü IndexNulls Ӽ   ȿ   ̺ Ʒ Enum  ϳ  ؾ մϴ.

adIndexNullsAllow     ε Ű  Null ׸ մϴ. Ű  Null  Էϸ ε ׸ Ե˴ϴ.
