mirror of
https://github.com/hwanny1128/HGZero.git
synced 2025-12-06 07:56:24 +00:00
19 lines
462 B
SQL
19 lines
462 B
SQL
-- minutes 테이블 구조 확인
|
|
SELECT
|
|
column_name,
|
|
data_type,
|
|
is_nullable,
|
|
column_default
|
|
FROM information_schema.columns
|
|
WHERE table_name = 'minutes'
|
|
ORDER BY ordinal_position;
|
|
|
|
-- Primary Key 확인
|
|
SELECT
|
|
kcu.column_name
|
|
FROM information_schema.table_constraints tc
|
|
JOIN information_schema.key_column_usage kcu
|
|
ON tc.constraint_name = kcu.constraint_name
|
|
WHERE tc.table_name = 'minutes'
|
|
AND tc.constraint_type = 'PRIMARY KEY';
|