This report will list table name and it's size,
In our company there is a table which is storing price-tick,of all symbols ,also storing Audit trail information,
which contained all the user activity information and market information etc, so periodically we need to check all the tables
SQL server also having very good report options, but I am using this , because it has some other reports use to analyse the DB.
This report will list table which don't have foreign-key, this report is very useful to cross check the table has missed any reference, useful while developing and debug the application
Report : Table has foreign key
Report : Table don't have constraints
Report : Table having any constraints
In our company there is a table which is storing price-tick,of all symbols ,also storing Audit trail information,
which contained all the user activity information and market information etc, so periodically we need to check all the tables
SQL server also having very good report options, but I am using this , because it has some other reports use to analyse the DB.
This report will list table which don't have foreign-key, this report is very useful to cross check the table has missed any reference, useful while developing and debug the application
Report : Table has foreign key
Report : Table don't have constraints
Report : Table having any constraints
No comments:
Post a Comment