what is the difference betweeen drop table and a drop database?

the same as the difference between a sock and a drawer

a database contains tables

drop a table, the table is gone, but drop a database, all the tables in it are gone too

sorry i am new can u detail it!

create table ttt(id,name,etc) in cdb195.cts195.

if this is my create command cdb195.cts195 is my tablespace right! then in which database does this table gets stored! Or if im right,the tablespace we define is the database ultimately!

the name of your tablespace is cts195 which belongs to the database cdb195

Hi Ravi,

If we want to create a table ...we should create it in a tablespace.
That is why you are using IN clause in your statement.

In "IN clause" you can specify the tablespace name only
or
Tablespace name prefixed by its database name

So here the prefix is your databse (i.e) cdb195.
The next part is your tablespace (i.e) cts195.

So your table will get created in table space 'cts195', which is there in database 'cdb195'.

Hope you are clear now....

Cheers...
Saidulu

Note: The term "database" in DB2 LUW stands for a completely different concept than in DB2 z/OS. A "database" In DB2 z/OS is basically a qualifier for table space names (as schemas are for table names), whereas a "database" in DB2 LUW is more like a subsystem in DB2 z/OS.