Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
You can use the query Yitzhak provided. Or you can run the following:
sp_help yourViewname
describe views
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,411
Reputation points
Hi Expert,
how we can view columns of the view
i.e. desc view view_name but can not see its column and datatype to copy and create new table using metadata
Azure Data Factory
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky 27,196 Reputation points2023-02-02T19:21:03+00:00 There is no need to use Answers for questions and comments.
-
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-02-06T07:53:56.44+00:00 I tested the query Yitzhak provided and it does show the view. You can try it.
-
Anonymous
2023-03-10T08:15:12.97+00:00 Hi @Shambhu Rai
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jingyang Li 5,901 Reputation points Volunteer Moderator2023-02-02T20:13:47.5666667+00:00 -
Yitzhak Khabinsky 27,196 Reputation points
2023-02-02T16:40:27.41+00:00 Hi @Shambhu Rai,
You can try to use INFORMATION_SCHEMA.COLUMNS.
Please see below.
USE AdventureWorks2019; GO SELECT * FROM AdventureWorks2019.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'vEmployee';-
Shambhu Rai 1,411 Reputation points
2023-02-02T17:29:42.7433333+00:00 IT IS not table it is view* not working above statement ...needs columns and datatype
-
-
Viorel 127K Reputation points2023-02-02T18:13:53.1666667+00:00 I think that it works for views too. Do you also want to create a new table that corresponds to the view?
-
Yitzhak Khabinsky 27,196 Reputation points
2023-02-02T19:19:19.86+00:00 It is working perfectly well with both tables as well as the views.
-
Anonymous
2023-02-03T02:19:23.0466667+00:00 Hi @Shambhu Rai
I tested it and it does show the view. You can remove the latter part of where first and replace 'AdventureWorks2019' in 'AdventureWorks2019. INFORMATION_SCHEMA. COLUMNS' to your database name.
Sign in to comment -