Please allow database views ( both spatial and non-spatial ) to be registered with the GeoDatabase in SDE.
As metadata can only be associated with objects registered with the GDB, and since views ( both spatial and non-spatial ) can't be registered with the GDB, we can not currenlty store metadata with database views.
This is a big gap in functionality between SDE v9.3.1 and SDE 10.x
This idea has been marked as a duplicate of Create Views In ArcCatalog Like In SDE Command Line by Nana Dei. Please consider voting for this idea.