--procedimiento para eliminar tabla
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsTarifasFleMay]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[paInsTarifasFleMay]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpTarifasFleMay]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[paUpTarifasFleMay]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTarifasFleMay]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[paQryTarifasFleMay]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TarifasFleMay_adm_Usuarios]') AND parent_object_id = OBJECT_ID(N'[dbo].[TarifasFleMay]'))
ALTER TABLE [dbo].[TarifasFleMay] DROP CONSTRAINT [FK_TarifasFleMay_adm_Usuarios]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TarifasFleMay_Agencias]') AND parent_object_id = OBJECT_ID(N'[dbo].[TarifasFleMay]'))
ALTER TABLE [dbo].[TarifasFleMay] DROP CONSTRAINT [FK_TarifasFleMay_Agencias]
GO
ALTER TABLE [dbo].[TarifasFleMay] DROP CONSTRAINT [CK_TarifasFleMayIdAgencia]
GO
ALTER TABLE [dbo].[TarifasFleMay] DROP CONSTRAINT [CK_TarifasFleMayIdUsuario]
GO
ALTER TABLE [dbo].[TarifasFleMay] DROP CONSTRAINT [CK_TarifasFleMayNitEmpresa]
GO
ALTER TABLE [dbo].[TarifasFleMay] DROP CONSTRAINT [CK_TarifasFleMayTipoLiquida]
GO
ALTER TABLE [dbo].[TarifasFleMay] DROP CONSTRAINT [CK_TarifasFleMayTipoTarifa]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TarifasFleMay]') AND type in (N'U'))
DROP TABLE [dbo].[TarifasFleMay]