sp_databases is a system stored procedure which will return all the databases in a SERVER along with the database sizes:
syntax for sp_databases stored procedure is:
Example:
Following picture represents the database information for all the databases in SQL Server .
syntax for sp_databases stored procedure is:
- sp_databases : This will return all databases information.
- sp_databases <database Name >: This will return only 1 particular Database information.
Example:
Following picture represents the database information for all the databases in SQL Server .
