用sql查看表结构

1.oracle

sql   = "Select column_name, data_type, data_length, nullable";

sql += " FROM user_tab_columns ";

sql += " where table_name='";

sql += $tableName;

sql += "'";

2.sql server

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;

文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags: columnscolumns 表结构表结构
相关日志: