How do you test your database?

This is a very generic question. I will be describing my generic database testing method as well as stored procedure testing methods.

Testing Databases:

• Table Column data type and data value validation.
• Index implementation and performance improvement.
• Constraints and Rules should be validated for data integrity.
• Application field length and type should match the corresponding database field.
• Database objects like stored procedures, triggers, functions should be tested using different kind of input values and checking the expected output variables.

Testing Stored Procedures:

• Understand the requirements in terms of Business Logic.
• Check that code follows all the coding standards.
• Comparing the fields' requirements of application to the fields retrieved by a stored procedure. they should match.
• Repeatedly run stored procedures many times with different input parameters and compare the output with expected results.
• Pass invalid input parameters and see if a stored procedure has good error handling..