Collections:
"sp_columns" - Getting a List of Columns in a View in SQL Server
How To Get a List of Columns in a View using the "sp_columns" Stored Procedure in SQL Server?
✍: FYIcenter.com
If you have an existing table, but you don't remember what are the columns defined in the view, you can use the "sp_columns" stored procedure to get a list of all columns of the specified view. The following tutorial script shows you a good example:
EXEC SP_COLUMNS fyi_links_top; GO TABLE_OWNER TABLE_NAME COLUMN_NAME TYPE_NAME LENGTH ----------- ------------- ----------- --------- ------ dbo fyi_links_top id int 4 dbo fyi_links_top counts int 4 dbo fyi_links_top url varchar 80 (3 row(s) affected)
The "sp_columns" stored procedure returns a long list of properties for each column of the specified view.
⇒ "sp_help" - Getting a List of Columns in a View in SQL Server
⇐ "sys.columns" - Getting a List of Columns in a View in SQL Server
2016-11-05, 2109🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...