Collections:
"sys.columns" - Getting a List of Columns in a View in SQL Server
How To Get a List of Columns in a View using "sys.columns" in SQL Server?
✍: FYIcenter.com
If you have an existing view, but you don't remember what are the columns defined in the view, you can use the "sys.columns" system view to get a list of all columns of all views in the current database.
In order to a list of columns of a single view, you need to join sys.columns and sys.views as shown in the tutorial example below:
SELECT * FROM sys.columns c, sys.views v WHERE c.object_id = v.object_id AND t.name = 'fyi_links_top' GO object_id name column_id user_type_id max_length ----------- ------- ---------- ------------ ---------- 1205579333 id 1 56 4 1205579333 counts 2 56 4 1205579333 url 3 167 80
You can see the column names easily from the sys.columns view. But you can only see the column type IDs. This requires another join to get the column type names. You may try the "sp_columns" stored procedure to get a better list of columns shown in the next tutorial.
⇒ "sp_columns" - Getting a List of Columns in a View in SQL Server
⇐ DROP VIEW - Deleting Existing Views in SQL Server
2016-11-05, 2153🔥, 0💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...