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, 1528🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...