如何从Oracle数据库中的表中获取列名(字段名)列表?
目录
如何从Oracle数据库中的表中获取列名(字段名)列表?
#示例一
#示例二
示例三:
#示例一
可以获取:
table_name:表名称;
column_name:数据列名称;
data_type:数据列类型;
data_length:数据长度;
SELECT table_name, column_name, data_type, data_lengthFROM USER_TAB_COLUMNSWHERE table_name = 'MYTABLE'
#select查询;
SELECT column_name FROM user_tab_cols WHERE table_name=UPPER('tableName');
#describe函数
describe YOUR_TABLE;
#示例二
如果数据库是SQL Server
Type = 'V' 是查询试图参数
Type = 'U' 是查询表参数
SELECT [name] AS [Column Name]FROM syscolumnsWHERE id = (SELECT id FROM sysobjects WHERE type = 'V' AND [Name] = 'Your table name')
示例三:
MySQL数据库;
SELECT column_name FROM information_schema.columns WHERE table_schema = 'Schema' AND table_name = 'Table_Name'
参考:SQL
参考:How can I get column names from a table in Oracle?