[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	9:07:33 PM Friday, December 05, 2008
Last Modified	6:55:54 PM Sunday, April 12, 2009

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