To execute SQL commands and queries ... their designs over time to match the application data usage pattern, for example by adding indexes for common queries, or by adding foreign key constraints ...

Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function to check the database status. The following example will show the database name ...