目录
如何从Oracle数据库中的表中获取列名(字段名)列表?
#示例一
#示例二
示例三:
#示例一
可以获取:
table_name:表名称;
column_name:数据列名称;
data_type:数据列类型;
data_length:数据长度;
SELECt table_name, column_name, data_type, data_length FROM USER_TAB_COLUMNS WHERe 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 syscolumns WHERe 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?
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)