| :: database views :: (2) | Post a New Message | Post a Reply |
 database views | Post a Reply |
since: Mar 20, 2006
from: somewhere
2) write a view so that it displays the
names of the views present in the database.
please send me mail to babu_manam@yahoo.co.in
| Re: database views | Post a Reply |
from: Washington, DC
For SQL Server, you can use the following statement to display all the views
SELECT name FROM SYSOBJECTS WHERE xtype = 'V' AND category = 0 -------------------------
Ghost