Home | History | Annotate | Line # | Download | only in mssql 
      1 drop procedure create_person
      2 drop procedure set_person_name
      3 drop procedure delete_phone
      4 drop procedure add_phone
      5 drop procedure make_doc_link
      6 drop procedure del_doc_link
      7 drop procedure delete_person
      8 
      9 drop procedure create_org
     10 drop procedure set_org_name
     11 drop procedure delete_org
     12 
     13 drop procedure create_document
     14 drop procedure set_doc_title
     15 drop procedure set_doc_abstract
     16 drop procedure make_author_link
     17 drop procedure del_author_link
     18 drop procedure delete_document
     19 
     20 if exists (select * from sysobjects where id = object_id(N'authors_docs') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     21 drop table authors_docs
     22 GO
     23 
     24 if exists (select * from sysobjects where id = object_id(N'documents') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     25 drop table documents
     26 GO
     27 
     28 if exists (select * from sysobjects where id = object_id(N'institutes') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     29 drop table institutes
     30 GO
     31 
     32 if exists (select * from sysobjects where id = object_id(N'persons') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     33 drop table persons
     34 GO
     35 
     36 if exists (select * from sysobjects where id = object_id(N'phones') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     37 drop table phones
     38 GO
     39 
     40