Creating a View avoiding some null columns from a table. : LUSENET : DBAzine : One Thread


My application has a table with more than 700 columns. Of which 220 odd is null.

Normally we specify the columns one after the other in the select statement of the view defnition . I wnat to know if there is a simple way to create a view avoiding these null columns?

thanks and regards Navaneeth.

-- Navaneeth (, February 04, 2004

Moderation questions? read the FAQ