SQL

[ad.hasareli]

machanla SQL Database table akaka thiyena data aka serema delete karana widiha mata kiyanakooo.... mama use karanne use karanne SQL sever 2008r2 ...

 

[epw]

delete * from tablename

 

[Chanaka_c.j]

jest select the shema and delete it from the options

 

[ad.hasareli]

delete * from tablename

me command aken table akama delete wenawada ban ????? mata table aka delete karanna ona nehe table ake thiyena data witarai delete karanna ona..... Anyway thanx machan..... rep +++

 

[epw]

me command aken table akama delete wenawada ban ????? mata table aka delete karanna ona nehe table ake thiyena data witarai delete karanna ona..... Anyway thanx machan..... rep +++

no. just data

 

[Madura6]

truncate table tablename

 

[blackcatcyb]

delete * from tablename

MEKEN TABLE EKA DELETE WENNE NE, TABLE EKE TIYENA DATA TIKA DELETE WENAWA. SURE NATTAN TABLE BACKUP EKAK GANNA.

 

[ad.hasareli]

delete * from tablename

jest select the shema and delete it from the options

no. just data

truncate table tablename

machanla wede goda help karapu hemotama thnxxx......rep++

 

[ad.hasareli]

truncate table tablename

Rathu karagena hitapu uba onna mama nill kara

 

[tharindudoo]

harine ehanam neda,

mulu table ekama makanna one nam,

drop table tablename

table eke data serama makanna one nam

delete * from tablename

mokak hari condition ekakin table eke data makanna one nam

delete * from tablename where studentId = 001
(studentId = 001 kiyanne condition eka)

 

[NO_MeRcY]

delete * from <tablename> වැරදියි . delete එක්ක * දාන්නෙ නෑ.


use this

DELETE FROM table
WHERE predicates;

table එකේ නම Student නම්

DELETE FROM Student

- Student table එකේ ඔක්කොම Data මැකෙනවා

predicates තියෙනව නම්

DELETE FROM Student where StuName = 'Elakiri'

likewise