GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → SQLBek → sp_helpExpandView

SQLBek / sp_helpExpandView

Licence: GPL-3.0 license
sp_helpExpandView takes a view & returns a list of all objects referenced underneath.

Programming Languages

SQLPL
141 projects

sp_helpExpandView

https://sqlbek.wordpress.com/2015/03/03/debuting-sp_helpexpandview/

sp_helpExpandView will take a view & return a list of all objects referenced underneath. V1 supports references to child views, tables, inline functions, table valued functions, and 1 level of synonyms.

Output comes in two formats – vertical and horizontal. Default is ‘all.’

Usage: EXEC sp_helpExpandView @ViewName = ‘[schema].[view]’, @OutputFormat = ‘[all|vertical|horizontal]’

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].