I’ve been playing around with some icon ideas for SQL Data Definition Language (DDL) and SQL Data Manipulation Language (DML) for some time. Perhaps they will give you some ideas.
First are the Basic DML Commands:
Now let’s apply them to Tables:
Tables need Primary Keys:
They may also need Unique Indexes:
We may have to play with the Columns:
Then we should have Views:
And in special cases Triggers:
We should also define Users:
Now we have all the DDL.
Let’s look at the DML:
Having manipulated our data we should either Commit or Rollback:
And that is about how far I’ve come.