1、MySql $tableName = 'test'; $sql = 'show create table '.$tableName; $rs = $db->execute($sql);2、Oracle //--查询字段的注释 注意owner,tablename名要大写!SELECT * FROM Dba_Col_Comments WHERE OWNER='QZUSER' AND TABLE_NAME='DEPT'//查询表结构select column_name,data_type from DBA_TAB_COLS where OWNER='QZUSER' and TABLE_NAME='DEPT'
show create table `tablename` 会包含comment部分
show create table `tablename`之后和平时一样的,当记录来读取。。
SELECT COLUMN_NAME, COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '数据表'
$tableName = 'test';
$sql = 'show create table '.$tableName;
$rs = $db->execute($sql);2、Oracle
//--查询字段的注释 注意owner,tablename名要大写!SELECT * FROM Dba_Col_Comments WHERE OWNER='QZUSER' AND TABLE_NAME='DEPT'//查询表结构select column_name,data_type
from DBA_TAB_COLS
where OWNER='QZUSER' and TABLE_NAME='DEPT'
会包含comment部分
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = '数据表'