The Tables collection contains Table objects referencing the system and user-defined tables of a Microsoft® SQL Server™ database.
With the Tables collection, you can:
To remove a table
Set oTable = oDatabase.Tables("[Order Details]", "dbo")
When using the Item or Remove method, the Tables collection supports member identification using either name or ordinal reference syntax. For example:
Set oTable = oDatabase.Tables("[Employees]")
Or:
Set oTable = oDatabase.Tables(1)
Additionally, when using name-based item selection, the Item method allows owner name qualification of the targeted SQL Server table as shown earlier. When using the Remove method, the Tables collection does not support qualification of targeted object by owner name. It is suggested that you use the Item method to extract the target, then use the Remove method of the Table object to drop a table.
Note Creating or removing SQL Server tables by using the Tables collection requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the fixed role db_ddladmin or a role with greater privilege.
Add Method | Refresh Method |
Item Method | Remove Method (Collections) |
ItemByID Method |