Hi all,
I want to extract constraints within the views definition.
for example in such a view definition query:
" create view student_view as select stdid, stdname from student_table where stdid > 675; "
how can i extract (stdid > 675) from any tables or views in Sql server 2000? (I don't like to parse "create view ..." query!)

-thanks in advance

in SQL Server 2000
open dB
right click view
all task\generate sql scripts
and follow the wizard