Delete Data from the Table with Management Studio GUI

Microsoft SQL Server 2017 for Everyone Manipulating Tables and Data
1 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€64.51
List Price:  €92.16
You save:  €27.65
£55.26
List Price:  £78.95
You save:  £23.68
CA$95.77
List Price:  CA$136.82
You save:  CA$41.05
A$105.61
List Price:  A$150.88
You save:  A$45.26
S$94.49
List Price:  S$134.99
You save:  S$40.50
HK$546.56
List Price:  HK$780.84
You save:  HK$234.27
CHF 64.51
List Price:  CHF 92.16
You save:  CHF 27.65
NOK kr745.92
List Price:  NOK kr1,065.65
You save:  NOK kr319.72
DKK kr481.76
List Price:  DKK kr688.26
You save:  DKK kr206.50
NZ$114.32
List Price:  NZ$163.32
You save:  NZ$49
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.19
৳8,200.05
List Price:  ৳11,714.86
You save:  ৳3,514.80
₹5,813.28
List Price:  ₹8,305.04
You save:  ₹2,491.76
RM329.26
List Price:  RM470.40
You save:  RM141.13
₦102,276.30
List Price:  ₦146,115.27
You save:  ₦43,838.96
₨19,447.66
List Price:  ₨27,783.57
You save:  ₨8,335.90
฿2,561.05
List Price:  ฿3,658.80
You save:  ฿1,097.75
₺2,253.54
List Price:  ₺3,219.48
You save:  ₺965.94
B$361.65
List Price:  B$516.66
You save:  B$155.01
R1,289.17
List Price:  R1,841.76
You save:  R552.58
Лв126.36
List Price:  Лв180.52
You save:  Лв54.16
₩95,655.33
List Price:  ₩136,656.33
You save:  ₩41,001
₪256.70
List Price:  ₪366.73
You save:  ₪110.03
₱4,073.73
List Price:  ₱5,819.86
You save:  ₱1,746.13
¥10,984.57
List Price:  ¥15,692.92
You save:  ¥4,708.34
MX$1,168.81
List Price:  MX$1,669.81
You save:  MX$500.99
QR254.92
List Price:  QR364.18
You save:  QR109.26
P949.81
List Price:  P1,356.93
You save:  P407.12
KSh9,122.85
List Price:  KSh13,033.20
You save:  KSh3,910.35
E£3,298.27
List Price:  E£4,712.01
You save:  E£1,413.74
ብር4,016.76
List Price:  ብር5,738.47
You save:  ብር1,721.71
Kz59,376.64
List Price:  Kz84,827.41
You save:  Kz25,450.77
CLP$63,605.87
List Price:  CLP$90,869.43
You save:  CLP$27,263.55
CN¥497.66
List Price:  CN¥710.97
You save:  CN¥213.31
RD$4,116.79
List Price:  RD$5,881.38
You save:  RD$1,764.59
DA9,406.51
List Price:  DA13,438.44
You save:  DA4,031.93
FJ$158.71
List Price:  FJ$226.74
You save:  FJ$68.02
Q543.03
List Price:  Q775.80
You save:  Q232.76
GY$14,626.09
List Price:  GY$20,895.31
You save:  GY$6,269.22
ISK kr9,653.57
List Price:  ISK kr13,791.40
You save:  ISK kr4,137.83
DH697.32
List Price:  DH996.21
You save:  DH298.89
L1,240.19
List Price:  L1,771.78
You save:  L531.58
ден3,973.31
List Price:  ден5,676.40
You save:  ден1,703.09
MOP$562.57
List Price:  MOP$803.71
You save:  MOP$241.13
N$1,284.81
List Price:  N$1,835.52
You save:  N$550.71
C$2,572.99
List Price:  C$3,675.86
You save:  C$1,102.87
रु9,296.83
List Price:  रु13,281.76
You save:  रु3,984.92
S/261.34
List Price:  S/373.37
You save:  S/112.02
K271.67
List Price:  K388.13
You save:  K116.45
SAR262.50
List Price:  SAR375.02
You save:  SAR112.51
ZK1,865.84
List Price:  ZK2,665.60
You save:  ZK799.76
L320.98
List Price:  L458.57
You save:  L137.58
Kč1,589.64
List Price:  Kč2,271.01
You save:  Kč681.37
Ft24,759.44
List Price:  Ft35,372.15
You save:  Ft10,612.70
SEK kr760.40
List Price:  SEK kr1,086.34
You save:  SEK kr325.93
ARS$62,235.70
List Price:  ARS$88,911.95
You save:  ARS$26,676.25
Bs483.06
List Price:  Bs690.12
You save:  Bs207.05
COP$270,493.43
List Price:  COP$386,435.76
You save:  COP$115,942.32
₡35,841.38
List Price:  ₡51,204.17
You save:  ₡15,362.78
L1,727.58
List Price:  L2,468.08
You save:  L740.49
₲525,820.15
List Price:  ₲751,203.84
You save:  ₲225,383.69
$U2,694.45
List Price:  $U3,849.38
You save:  $U1,154.93
zł274.83
List Price:  zł392.63
You save:  zł117.80
Already have an account? Log In

Transcript

You guys Continuing from our last video where we did a few SQL commands to delete some records, we will look at how we can go about deleting records using the editor itself. So if we right click our table and once again go to Edit top 200 rows from this view, you can actually select the row that you would like to remove and go ahead and right click and press delete or just press Delete on your keyboard. So we can go about removing student number 11 and we just press Delete and at least here it will ask Are you sure you want to delete these rules so you can just click Yes, and then it will do the script in the background and readjust accordingly. A script is a nice automated way to effect multiple changes multiple times but by writing it one time, however, if you use the editor and you had a million rows, it would be a bit more difficult to comb through these rows to find the one that you want to delete or you could actually just modify the SQL statement to find the exact rules that you want to delete.

And then you could just select them all and press Delete. It's a matter of which one is more efficient to do remember that scripts are actually shareable. So if you do it on your machine, you can share with somebody else who may have the same problem or need as you do with their database.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.