IT-Academy

Selekcia-db-objekty

Oct 4th, 2017
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | None | 0 0
  1. SELECT schemaname FROM syscat.schemata;
  2.  
  3. SELECT name, tbname, coltype FROM sysibm.syscolumns;
  4.  
  5. SELECT name FROM sysibm.systables;
  6.  
  7. SELECT tbname FROM sysibm.syscolumns WHERE name=’username’
Advertisement
Add Comment
Please, Sign In to add comment