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