ÓÃsql²é¿´±í½á¹¹

1.oracle
 sql   = "SELECT column_name, data_type, data_length, nullable";
 sql += " from user_tab_columns ";
 sql += " where table_name='";
 sql += $tableName;
 sql += "'";
 select * from user_tab_comments   ²éѯ±íÃû¼°±í˵Ã÷£¨comment)
 select * from user_col_comments    ²éѯ±í¼°±íÖÐ×ֶεÄ˵Ã÷
2.sql server
select  name,xtype,length,isnullable  from  syscolumns
where id =(select  top 1 Id   from  sysobjects  where name = '±íÃû');
 
 sql   = "select  name,xtype,length,isnullable  from  syscolumns where id =";
 sql += " (select  top 1 Id   from  sysobjects  where name = '";
 sql += $tableName;
 sql += "')";
3.my sql
 sql   = "show columns from ";
 sql += $tableName;
»ò
 sql   = "desc ";
 sql += $tableName;
»ò
 sql   = "describe ";
 sql += $tableName;