if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Supplier]>
drop table [dbo].[Supplier]
GO

CREATE TABLE [dbo].[Supplier] (
        [SupplierID] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
        [DepartmentID] [int] NOT NULL ,
        [CityID] [int] NOT NULL ,
        [SupplierName] [varchar] ( 1 ) ,
        [IsProducer] [bit] NOT NULL ,
        [LegalAddress] [varchar] ( 1 )  ,
        [IsSpecDep] [bit] NOT NULL ,
        [ParentID] [int] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Supplier] WITH NOCHECK ADD
        CONSTRAINT [PK_Supplier] PRIMARY KEY  CLUSTERED
        (
                [SupplierID]
        )  ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getSupplier]') and OBJECTPROPERTY(id, N'IsProcedure') =  1 )
drop procedure [dbo].[getSupplier]
GO


Create PROCEDURE dbo.getSupplier

AS

set nocount on

SELECT  * FROM   dbo.Supplier