Creating a View avoiding some null columns from a table.

greenspun.com : LUSENET : DBAzine : One Thread

Hi

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 (navaneeth_kumar@hotmail.com), February 04, 2004


Moderation questions? read the FAQ