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 belwo 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.
Â
2016-11-05, 1099👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...