06-1.MS_SQL 2008 - Delete문

--[4] 4.Delete(삭제)문: 레코드단위로삭제...

--(정의) Delete TableName [Where 조건]

 

--Delete

--Where

 

--[5] Memos에서이름이'천두산'인사람의모든것삭제

Delete Momos

Where

       name = '천두산'

Go

 

Select *From Momos Where name= '천두산'

Go

 

--[6] Memos의모든자료삭제

Delete Momos

Go

 

Select *From Momos

Go

 

--테이블삭제

Drop Table dbo.Momos

Go

---

06-1Delete.sql