주저리주저리.....

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

명혀니 2014. 4. 16. 10:06
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'