1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| SELECT
kcu.TABLE_NAME,
kcu.COLUMN_NAME,
kcu.CONSTRAINT_NAME,
tc.CONSTRAINT_TYPE,
c.IS_NULLABLE
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu
JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc ON kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
AND kcu.TABLE_SCHEMA = tc.TABLE_SCHEMA
JOIN INFORMATION_SCHEMA.COLUMNS c ON kcu.TABLE_NAME = c.TABLE_NAME
AND kcu.COLUMN_NAME = c.COLUMN_NAME
AND kcu.TABLE_SCHEMA = c.TABLE_SCHEMA
WHERE
tc.CONSTRAINT_TYPE = 'UNIQUE'
AND kcu.TABLE_SCHEMA = DATABASE()
AND c.IS_NULLABLE = 'YES'
ORDER BY
kcu.TABLE_NAME,
kcu.CONSTRAINT_NAME;
|