主题：怎样为已存在的外部表增加系统列_sortkey和_Locked列？

mark 修改表结构

Dim cn As new ADODB.Connection()
Dim ca As new ADOX.Catalog

cn.Open(Connections("test").ConnectionString , Nothing, Nothing, -1)
Ca.ActiveConnection = cn

Dim tbl = ca.Tables("外部表")

tbl.Columns.Append("_Locked", ADOX.DataTypeEnum.adBoolean)
tbl.Columns.Append("_Sortkey", ADOX.DataTypeEnum.adDouble)

cn.Close()
ca = Nothing