drop

[MSSQL] 테이블 전체 삭제 하는 쿼리

DECLARE@QUERYNVARCHAR(MAX) ,@TABLENAMENVARCHAR(MAX) ,@FOREIGNKEYNAMENVARCHAR(MAX) ,@KEYTYPENVARCHAR(MAX) DECLARE FOREIGNKEY_CURSOR CURSOR FOR /*****[외래키 걸린것만 삭제 할때 ]**************************************************/ SELECTFKN.CONSTRAINT_NAME AS FK_Name ,FKT.TABLE_NAME AS FK_Table FROMINFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS FKN INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FKT ON FKN.CONSTR..