The sql server provides a procedure to get the information of desired data base .i;e SP_HELPDB.
In the below picture we can see the data and log information of the database.Here i have used query to get the data of existing database.
The result will show the size,administrator and status of the DB
In the below picture we can see the data and log information of the database.Here i have used query to get the data of existing database.
sp_helpdb 'Test krishna'
