Delete Statement -دستور حذف سطرها از جدول

دستور حذف Record های یک جدول: 

Delete From [TableName(نام جدول)] ;

Delete From Products ;=>حذف تمامی محصولات  

Delete From Categories where CategoryName='Seafood' ;

Delete From [نام جدول] Where [نام ستون]=[Value(مقدار)] ;

Delete From Products Where CategoryID=1; 

Delete From Products Where ProductName Like '%C%' Or ProductName Like '%D%'  

Delete From Products Where ProductName Like '%C%' Or Not ProductName Like '%D%'