Creating View

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Write a select statement pulling back the metadata to do most of the work for you and execute it in QA:

SELECT COLUMN_NAME + '1,
' FROM INFORMATION_SCHEMA.Columns
WHERE TABLE_NAME = '<Your table name>'
ORDER BY ORDINAL_POSITION

Copy the resulting output and add on your CREATE VIEW and FROM statements and you have your DDL query to create the view.

K. Brian Kelley
@kbriankelley