-
这里总结几个数据库的查询所有表字段名和字段类型的SQL语句:
Mysql database:
select COLUMN_NAME, DATA_TYPE from information_schema.COLUMNS where table_name =
注意:这样查询能把所有数据库中table_name为该名字的表查询出来;如果要指定数据库可以所有下面的语句:
select COLUMN_NAME,DATA_TYPE from information_schema.COLUMNS where table_name = ' tableName' and table_schema = ' database ';
Oracle database:
select column_name, data_type from all_tab_columns where TABLE_NAME =
SQLServer database
select column_name,data_type from information_schema.columns where table_name =
Postgresql database
select column_name, data_type from information_schema.columns where table_name = 'ahnavi' ORDER BY ordinal_position;