Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Question Unanswered: SQL Servers view meta data(urgent)

    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

  2. #2
    Join Date
    Nov 2004

    use the wizard

    in SQL Server 2000
    open dB
    right click view
    all task\generate sql scripts
    and follow the wizard
    to err is human ; to really mess things up requires a computer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts