[dbo].[mdb_installed

[dbo].[mdb_installed_schemas]

(local) > mdb > Views > dbo.mdb_installed_schemas

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:23:55 AM Sunday, December 05, 2010
Last Modified	10:23:55 AM Sunday, December 05, 2010

Columns

Name
SchemaName
ObjectCount

Permissions

Type	Action	Owning Principal
Grant	Select	public

SQL Script

CREATE VIEW "mdb_installed_schemas"
AS
SELECT   SchemaName, COUNT(*) AS ObjectCount
FROM     mdb_schema_information
WHERE    (FileStatus <> 'Deleted')
GROUP BY SchemaName
GO
GRANT SELECT ON  [dbo].[mdb_installed_schemas] TO [public]
GO

Uses

[dbo].[mdb_schema_information]
dbo