rahultripathi

 Profile Answers by rahultripathi 

• Sep 22nd, 2005

 

View is vartual table based on record set of select statement. View cantain the field from  on one or more than one table's fields. The using view we can use JOIN and where statement and IT' s looks like single table .

Ex:- Create View view_name AS SELECT Column(s)  from TABLEname

where Condition

Any problem in anywhere Don't Hesitate write rahultripathi@myway.com   

SankaraNarayanan

• Oct 3rd, 2005

 

View is the only part of existing table(Collection Cols) and we have to collect the no of col from table and we get  one view.The Max no.of col in view as 1024.

starmile

 Profile Answers by starmile 

• Jan 2nd, 2006

 

View is a logical partition of one or more table in horizontally(by putting condition) or vertically (by including selected columns).

 View can be used to update table, provides security mechanism.

view defionition(qurey) stored as plan text or Encrypted text

We can see view definition by using following stored procedure

exec sp_helptext viewname