Tuesday, May 20, 2014

SQL Quiz: Which command did I run?



I have a small DB2 test database which I wanted to clean up. I ran a command which has the output below. Which command was it?

Table/View                      Schema          Type  Creation time            
------------------------------- --------------- ----- --------------------------
FOO                             HLOESER         T     2014-03-19-12.14.19.598515
INUSE                           HLOESER         T     2014-05-08-11.49.18.419975

  2 record(s) selected.


BTW: The command can be found in the IBM Knowledge Center which will be/is replacing and integrating the DB2 Information Center.

2 comments:

Nallu Suppiah said...

db2 list tables for schema HLOESER

Henrik Loeser said...

That was quick and correct! I only did "list tables", but was connected as user "hloeser". So it was the same result.

Henrik

LinkWithin

Related Posts with Thumbnails