<div id="readability-page-1" class="page"><div>
	<article id="post-13025">
	
		
	
<div>

		

		<p><i></i> <span><span>HYEONG HWAN, MUN</span></span><span>/</span><i></i> <span>9월 27, 2025</span><span>/</span><i></i> <a href="https://blog.lael.be/post/category/uncategorized" rel="category tag">미분류</a><span>/</span> <a href="https://blog.lael.be/post/13025#respond">0 comments</a></p><p>https://blog.lael.be/post/13025</p>
		
		
		

		
<p>확인 쿼리</p>
<pre>SELECT tc.CONSTRAINT_SCHEMA,
tc.TABLE_NAME,
tc.CONSTRAINT_NAME,
cc.CHECK_CLAUSE
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
JOIN INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
ON tc.CONSTRAINT_SCHEMA = cc.CONSTRAINT_SCHEMA
AND tc.CONSTRAINT_NAME = cc.CONSTRAINT_NAME
WHERE tc.CONSTRAINT_TYPE = 'CHECK';</pre>

<p>DROP 쿼리</p>
<pre>SELECT CONCAT(
'ALTER TABLE `', tc.CONSTRAINT_SCHEMA, '`.`', tc.TABLE_NAME,
'` DROP CHECK `', tc.CONSTRAINT_NAME, '`;'
) AS drop_statement
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
WHERE tc.CONSTRAINT_TYPE = 'CHECK';</pre>

		
		
		

		

		
		
		

		
	</div>	</article>
</div></div>

Lael's World

확인 쿼리 SELECT tc.CONSTRAINT_SCHEMA, tc.TABLE_NAME, tc.CONSTRAINT_NAME, cc.CHECK_CLAUSE FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc JOIN INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc ON tc.CONSTRAINT_SCHEMA = cc.CONSTRAINT_SCHEMA AND tc.CONSTRAINT_NAME = cc.CONSTRAINT_NAME WHERE tc.CONSTRAINT_TYPE = 'CHECK';   DROP 쿼리 SELECT CONCAT( 'ALTER TABLE `', tc.CONSTRAINT_SCHEMA, '`.`', tc.TABLE_NAME, '` DROP CHECK `', tc.CONSTRAINT_NAME, '`;' ) AS drop_statement FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc WHERE tc.CONSTRAINT_TYPE = 'CHECK';

drop all mysql check constraints

댓글