Listing 1: Creation Script for the INFORMATION_SCHEMA.USERTABLES View USE master GO EXEC sp_configure 'allow updates', 1 RECONFIGURE WITH OVERRIDE GO IF OBJECT_ID('INFORMATION_SCHEMA.USERTABLES') IS NOT NULL DROP VIEW INFORMATION_SCHEMA.USERTABLES GO CREATE VIEW INFORMATION_SCHEMA.USERTABLES AS SELECT USER_NAME(uid) AS owner, name FROM sysobjects WHERE type = 'u' GO EXEC sp_configure 'allow updates', 0 RECONFIGURE WITH OVERRIDE GO