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

Categories: Database; Tagged with: Derby; @ 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

Derby: Create, Drop, Rename Table 创建/删除/重命名 Derby表 <-> 使用SQuirreL(Universal) SQL Client管理Derby数据库

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects