흔히 쓰이는 구성요소(DB)

1 2 3 4

--테이블 Select 'Drop Table ' + name As Command From sys.objects Where type='U'

 

 

?

1 2 3 4

--저장 프로시저 Select 'Drop Procedure ' + name As Command From sys.objects Where type='P'

 

 

?

1 2 3 4

--뷰 Select 'Drop View ' + name As Command From sys.objects Where type='V'

 

 

?

1 2 3 4

--함수 Select 'Drop Function ' + name As Command From sys.objects Where type='PN'