← All Articles

SQL 명령어 컬럼명으로 테이블찾기

Posted on

Mssql

컬럼명으로 테이블 찾기

  • 컬럼명이 정확할때
SELECT  TABLE_NAME,
  COLUMN_NAME,
  DATA_TYPE,
  CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = '컬럼명'
  • 컬럼명이 정확하지 않을떄
SELECT  TABLE_NAME,
  COLUMN_NAME,
  DATA_TYPE,
  CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME like '%컬럼명%'

Mysql

컬럼명으로 테이블 찾기

  • 컬럼명이 정확할때
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME='컬럼명';
  • 컬럼명이 정확하지 않을떄
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%컬럼명%';
  • 스키마를 알고 있을때
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%컬럼명%' AND TABLE_SCHEMA='디비명';
Mysqlmysqlmssqldatabase