A system stored procedure called sp_helpdb allows you to view database information.
The sp_helpdb returns information like the database name, size, owner, ID, date of creation, various database setting and options, compatibility level etc.
To return information about a database :
EXEC sp_helpdb 'Northwind'
GO
If you want to return information about all databases :
EXEC sp_helpdb;
GO
No comments:
Post a Comment