1and1 Help Centre Categories

print article

Delete Data or Records from Tables Using myLittleAdmin

For Windows packages.

In this article you will be shown how to delete data from an MSSQL table.

There are two methods for deleting data from a table. If you have already Set a Primary/Unique Key for your Table, use Method One. If you have not set a primary key, use Method Two.


Method One
Step 2
Click Databases, then select your database.
myLittleAdmin > Databases > your specific database
myLittleAdmin > Databases > your specific database
Step 3
Select Tables and click the Content icon. Tables > Content
Tables > Content
Step 4
Check the corresponding box for the record(s) you want to delete and click the red X icon.
Table Content overview page
Table Content overview page
Step 5
You will be asked if you are sure that you want to delete the data. Click OK.
Window appearing and asking you to confirm the deletion
Window appearing and asking you to confirm the deletion

Method Two
Step 1
Select Tools and click Query Analyser.
myLittleAdmin > Tools > Query Analyser
myLittleAdmin > Tools > Query Analyser
Step 2
In the text field, input delete from (table name) and click Submit.
Query Analyser text field in which to type the command > Submit
Query Analyser text field in which to type the command > Submit