| Product: | DBConnectivity Products for IBM Db2 for i (HiT ODBC/400, HiT OLEDB/400, Ritmo/i, HiT JDBC/400) |
| Version: | All |
| ID: | 1047 |
| Summary: | Syntax for dropping a table on IBM i |
The following SQL command allows a user to drop a table on the IBM i:
DROP TABLE LIBNAME.TABLENAME
If the library is specified in the data source configuration, you can use this command:
DROP TABLE TABLENAME
You can do this on the PC side using a pass-through query with Microsoft Access, or from a Visual Basic application.
To drop a table using interactive SQL on the IBM i, the syntax is slightly different:
DROP TABLE LIBNAME/TABLENAME
Note: From SQL Server, you cannot create, modify or delete a table using a linked server or openquery/openrowset command.