How tables and columns can be validated in the database?

1.	How tables and columns can be validated in the database?
Answer» Are the naming conventions of fields are as per requirement? Are the lengths and sizes of fields are matching the requirement? CREATE a test case that will check if there is any unmapped or unused table and column. Is the MAPPING of database fields is correct and COMPATIBLE with the REQUIRED mappings? Check if table DESIGNS are applied correctly and are scalable.

Discussion