Derby: Show Tables – Get get existing tables 获取所有表

Categories: Database; Tagged with: ; @ September 15th, 2010 20:59

Derby并为提供对Show Tables的支持, 但可通过如下方式获取所有Table:

Get existing table names 获得已有Table名称列表

SELECT TABLENAME FROM SYS.SYSTABLES WHERE TABLETYPE='T';

Check Table Exists 检查Table是否已存在

SELECT TABLENAME FROM SYS.SYSTABLES WHERE TABLETYPE='T' AND TABLENAME LIKE 'tableName';

有用的链接: http://old.nabble.com/Howto-get-existing-table-names-td14524593.html

<->



// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.