Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- exec sys.sp_helptext ObjectName
- select text from syscomments where id =
- OBJECT_id('objectname')
- order by colid
- -- This generates view definitions
- --
- select definition + char(10) + 'go' + char(10)
- from sys.sql_modules c
- join sys.objects o
- on c.object_id = o.object_id
- join #views o2
- on o.object_id = o2.object_id
- select o.name
- ,o.object_id
- into #views
- from sys.objects o
- join sys.schemas s
- on s.schema_id = o.schema_id
- where o.type in ('V')
- and s.name = @schema
- SELECT * FROM sysobjects
- WHERE name LIKE 'dm_%'
- order by name
- exec sp_helptext N'sys.dm_os_sys_info'
- CREATE VIEW sys.dm_os_sys_info AS
- SELECT *
- FROM OpenRowset(TABLE SYSINFO)
Add Comment
Please, Sign In to add comment