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-
INUSE                           HLOESER         T     2014-05-08-

  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.


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.



Related Posts with Thumbnails