code_junkie

In SQL Server 2000, is there a sysobjects query that will retrieve user views and not system views?

Nov 10th, 2011
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. select * from information_schema.tables
  2. WHERE OBJECTPROPERTY(OBJECT_ID(table_name),'IsMSShipped') =0
  3.  
  4. where table_type = 'view'
  5.  
  6. SELECT
  7. *
  8. FROM
  9. sysobjects
  10. WHERE
  11. xtype = 'V' AND
  12. type = 'V' AND
  13. category = 0
  14.  
  15. select * from information_schema.tables
  16. where table_type = 'view'
Add Comment
Please, Sign In to add comment