sql: 查询,select

快速查询数据库中拥有那些表项:(类似linux中的ls, ls |grep table_name*)
select * from tab where tname like 'YOUR_QERYNAME%%';

TNAME          TABTYPE  CLUSTERID

-----------------------------------------

YOUR_QERYNAME       TABLE
YOUR_QERYNAME_xxx       TABLE
YOUR_QERYNAME_yyyy       TABLE
....

  

上一篇:python 颜色定义


下一篇:homework-06-C++11