Click here to Skip to main content
15,666,902 members
Articles / Database Development / SQL Server


5 bookmarked

Verifying Database Design Issues Against Predefined Quality Rules Using Schema Views

Rate me:
Please Sign up or sign in to vote.
5.00/5 (8 votes)
6 Dec 2016CPOL4 min read
This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.


Daily Counts


Weekly Counts


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By
Product Manager Avanza Solutions
Pakistan Pakistan
Asif has started programming back in 1991 on 80286 8-16 MHZ systems. Starting from dBase III+, FoxPro, C, assembly (exceptional skills in Assembly language have added significant confidence in his development career). The programming saga continues exploring new technologies and languages ranging from C++, VC++, Java, Delphi, RPG400, SQL Server, Oracle to name a few and the exploration still continues to DOT Net Technologies, SOA architectures, BI, DSL, etc. These learning experiences are backed by strong theoretical background with a flavor of research.

Asif shows significant interest in reading fiction, biotechnology, Astronomy. He Loves watching movies and in his free time love to play with his kids.

Comments and Discussions