Timeline for Select Columns of a View
Current License: CC BY-SA 3.0
7 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Sep 25, 2015 at 4:34 | history | edited | prabhat | CC BY-SA 3.0 |
improved answer with explaination
|
Sep 24, 2015 at 6:06 | comment | added | Arulkumar |
Instead of multiple tables on FROM clause, you can use JOIN . So the query will be SELECT col.name FROM sys.columns col JOIN sys.views vew ON col.object_id = vew.object_id WHERE vew.name = '<view_name>'
|
|
S Sep 24, 2015 at 5:51 | review | Low quality answers | |||
Sep 24, 2015 at 6:03 | |||||
S Sep 24, 2015 at 5:51 | review | Late answers | |||
Sep 24, 2015 at 5:53 | |||||
Sep 24, 2015 at 5:34 | comment | added | Kumar Saurabh | welcome to stack, whenever you answer a problem always try to explain how the solution will help the asker. please take some time and edit your answer | |
Sep 24, 2015 at 5:29 | review | First posts | |||
Sep 24, 2015 at 5:34 | |||||
Sep 24, 2015 at 5:28 | history | answered | prabhat | CC BY-SA 3.0 |