MYSQL ORACLE 查询表名及字段--封装代码自动生成时用
来源:互联网 发布:商城html源码下载 编辑:程序博客网 时间:2024/06/06 05:53
1. mysql查询所有表、视图
SELECT
table_name as tablename,
table_comment as tablecomment
FROM
information_schema.TABLES
2. mysql查询列信息
SELECT
mysql' dialect,
TABLE_NAME AS tablename,
COLUMN_NAME AS columnname,
DATA_TYPE AS datatype,
CHARACTER_MAXIMUM_LENGTH AS cml,
COLUMN_COMMENT AS columncomment,
CASE COLUMN_KEY WHEN 'PRI' THEN 1 WHEN 'MUL' THEN 2 END AScolumnkey
FROM
information_schema.COLUMNS
3. ORACLE查询所有表、视图
select
table_name as "tablename",
table_type as "tabletype",
comments as "tablecomment"
from user_tab_comments
4. ORACLE查询表的列信息
SELECT
'oracle' dialect,
utc.table_name AS tablename,
utc.column_name AS columnname,
utc.data_type AS datatype,
utc.data_length AS cml,
ucc.comments AS columncomment,
CASE ucon.constraint_type
WHEN 'P' THEN '1'
WHEN 'R' THEN '2'
ELSE ''
END
AS columnkey
FROM
user_tab_columns utc
LEFT JOIN user_col_comments ucc ON
ucc.column_name = utc.column_name
AND
ucc.table_name = utc.table_name
LEFT JOIN (
SELECT
cu.*,
au.constraint_type
FROM
user_cons_columns cu,
user_constraints au
WHERE
cu.constraint_name = au.constraint_name
AND
au.constraint_type IN (
'P','R'
)
) ucon ON
ucon.table_name = utc.table_name
AND
ucon.column_name = utc.column_name
WHERE
utc.table_name = 'TABLENAME'
SELECT
table_name as tablename,
table_comment as tablecomment
FROM
information_schema.TABLES
2. mysql查询列信息
SELECT
mysql' dialect,
TABLE_NAME AS tablename,
COLUMN_NAME AS columnname,
DATA_TYPE AS datatype,
CHARACTER_MAXIMUM_LENGTH AS cml,
COLUMN_COMMENT AS columncomment,
CASE COLUMN_KEY WHEN 'PRI' THEN 1 WHEN 'MUL' THEN 2 END AScolumnkey
FROM
information_schema.COLUMNS
3. ORACLE查询所有表、视图
select
table_name as "tablename",
table_type as "tabletype",
comments as "tablecomment"
from user_tab_comments
4. ORACLE查询表的列信息
SELECT
'oracle' dialect,
utc.table_name AS tablename,
utc.column_name AS columnname,
utc.data_type AS datatype,
utc.data_length AS cml,
ucc.comments AS columncomment,
CASE ucon.constraint_type
WHEN 'P' THEN '1'
WHEN 'R' THEN '2'
ELSE ''
END
AS columnkey
FROM
user_tab_columns utc
LEFT JOIN user_col_comments ucc ON
ucc.column_name = utc.column_name
AND
ucc.table_name = utc.table_name
LEFT JOIN (
SELECT
cu.*,
au.constraint_type
FROM
user_cons_columns cu,
user_constraints au
WHERE
cu.constraint_name = au.constraint_name
AND
au.constraint_type IN (
'P','R'
)
) ucon ON
ucon.table_name = utc.table_name
AND
ucon.column_name = utc.column_name
WHERE
utc.table_name = 'TABLENAME'
阅读全文
0 0
- MYSQL ORACLE 查询表名及字段--封装代码自动生成时用
- MySQL,SQLSERVER,ORACLE获取数据库表名及字段名
- oracle 查询表名和字段名
- sql & oracle 查询表的字段名
- Oracle 根据字段查询相关表名
- Sql Server 2008获取表的注释,字段名,字段类型,字段描述等,代码自动生成必备
- mysql查询数据库,表名和字段
- MySQL表名、字段、查询大小写问题
- mysql查询某个表所有字段名
- Oracle查询表名及列名
- Oracle中已知字段名查询所在的表名
- 查询oracle表中的字段名和字段类型
- 查询mysql数据库中的表名以及字段名
- 查询脚本,实现oracle数据库表及字段名全部设置为大写
- mysql中查询数据库中所有的字段及表,数据库名
- mysql 数据表名,字段名查询
- oracle修改字段名及字段长度
- oracle修改字段名及字段类型
- 一文理解深度学习,卷积神经网络,循环神经网络的脉络和原理2-卷积神经网络
- brew直接安装解压工具
- java后台调用接口并且传递相关参数
- 每天一个linux命令(39):grep 命令
- pva &yolo2
- MYSQL ORACLE 查询表名及字段--封装代码自动生成时用
- 程序包org.apache.http不存在,解决方式
- 整合MVP+Retrofit2+RxJava2
- maven scope含义的说明
- 关于serialVersionUID的说明
- linux 串口编程详解
- java读取配置文件Properties
- 云计算3A竞赛开跑,投资者"看涨"阿里云
- maven笔记