You can use the following query to select and display the table names of the database
SELECT *
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
Once you get the lists of table you can pass the selected table name to the following query to get the list of records.
SELECT *
FROM TableName
The delete and update commands are a little bit tricky. You may need to know the primary key of the table.However the update also depends on which columns are going to be updated.
Here is how to list only the primary key columns of the table.
Exec sp_primarykey TableName
Here is how to list all columns of the table.
SELECT
* FROM sys.columns WHERE object_id = OBJECT_ID(TableName)
Once you get the list of primary key and the rest of columns you will build your where statement string
For Delete
Delete SQL Statement[
^]
DELETE
FROM TableName
WHERE Criteria
For Update
Update SQL Statement[
^]
UPDATE TableName
SET ColumnsList
WHERE Criteria
This is basically what you need to do. There may be little additional work and tune ups.