Get list of Tables where a specific user is dbo..

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

There are TONS of ways. Here's one simple one:

SELECT * FROM [INFORMATION_SCHEMA].[TABLES]

WHERE TABLE_SCHEMA = 'dbo'

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt