Getting started with db2 Combine multiple rows into a single comma separated value Hello World;Insert into one table by selecting from another table Where not in multiple columns Parse comma-separated values in a column into multiple rows dashDB Copy table with or without data DB2 Constraint Information Drop table

Drop table

Basic Drop Table Syntax

db2 connect to {databaseName}
db2 drop table {schema}.{table}
db2 connect reset

The schema is not necessary if it matches the current user name. The "db2" prefix is not necessary if you are already in a DB2 command prompt.

Contributors

Topic Id: 10115

Example Ids: 31044

This site is not affiliated with any of the contributors.