Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from information_schema.tables
- WHERE OBJECTPROPERTY(OBJECT_ID(table_name),'IsMSShipped') =0
- where table_type = 'view'
- SELECT
- *
- FROM
- sysobjects
- WHERE
- xtype = 'V' AND
- type = 'V' AND
- category = 0
- select * from information_schema.tables
- where table_type = 'view'
Add Comment
Please, Sign In to add comment