Further schema comparison

The following is an extension of the previous post.

This is useful when dealing with sql server 2005 and custom schema’s.

(That is the prefix before database objects, not the structure of the database).


select tableName=SO.name, schemaName = SS.Name

from sysobjects SO

join sys.schemas SS ON SO.uid = SS.[schema_id]

where type = ‘U’

order by SO.name

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s