if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Supplier]') and OBJECTPROPERTY(id, N'IsUserTable') =  1 )
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] [MiddleString] NOT NULL ,
	[IsProducer] [bit] NOT NULL ,
	[LegalAddress] [MiddleString] NOT NULL ,
	[IsSpecDep] [bit] NOT NULL ,
	[ParentID] [int] NULL 
) ON [PRIMARY]
GO

CREATE PROCEDURE dbo.getSupplier

AS

set nocount on

 SELECT     SupplierID, DepartmentID, CityID, SupplierName, IsProducer, LegalAddress, IsSpecDep, ParentID
FROM         dbo.Supplier
GO

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