As you can see this is the number of stored procedure that I have been working at. Yup its pretty clear right? 1061 stored procedure
Check out the views and table. Obviously the number of views simply outrun the number of tables. Views play a very vital part in my system. Views are virtual tables which helps you integrate tables using sql queries but act as if it is a real table. In sql, accessing the views directly like inserting, deleting and updating records generates an error. Im not sure why but i guess its one way of protecting the sql tables. If ever you have a solution for this do tell me. As far as my knowledge is concern the only way you modify the data is by accessing the exact tables.
The last but not the least the diagram. I may have a few number of diagram but I have an enormous amount of trigger. Here is the sample:
I may haven't shown you the number of trigg…