list of sql database views

Question

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

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

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 1

One way is to query the Information Schema view for such information:

SELECT TABLE_SCHEMA, TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'VIEW'

K. Brian Kelley
@kbriankelley

samir_issa Grasshopper Points: 14 More actions · Answer 2

Grasshopper

Points: 14

May 10, 2008 at 8:17 am

Thanks, it is working perfect.