Collections:
"sp_help" - Getting a List of Columns in a View in SQL Server
How To Get a List of Columns in a View using the "sp_help" Stored Procedure in SQL Server?
✍: FYIcenter.com
Another way to get a list of columns from a view is to use the "sp_help" stored procedure. "sp_help" returns more than just a list of columns. It returns: the view information, the column information, the identity column, the row GUID column. The tutorial exercise below shows you what you will get with sp_help:
EXEC SP_HELP fyi_links_top; GO Name Owner Type Created_datetime -------------- ------ ----- ----------------------- fyi_links_top dbo view 2007-05-19 13:43:46.983 Column_name Type Computed Length Prec Scale Nullable ------------ -------- --------- ------- ----- ----- -------- id int no 4 10 0 yes counts int no 4 10 0 yes url varchar no 80 no Identity --------------------------- No identity column defined. RowGuidCol ----------------------------- No rowguidcol column defined.
⇒ Generating CREATE VIEW Scripts on Existing Views in SQL Server
⇐ "sp_columns" - Getting a List of Columns in a View in SQL Server
2016-11-05, 1623🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...