USE [METRICAS]
GO

--****** Object      : StoredProcedure [dbo].[PROC_SYS_Tablas_Campo]
--****** Autor       : Jorge Sánchez  
--****** Script Date : 07/12/2015 09:35:32 

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[PROC_SYS_Tablas_Campo]
   @Columna varchar(100)
AS
	SELECT A.name AS Tabla,
	CASE
		WHEN A.xtype = 'U' THEN 'Tabla'
		WHEN A.xtype = 'V' THEN 'Vista'
	END AS Tipo,
	B.name AS Columna
	FROM sysobjects A,syscolumns B
	WHERE A.Id = B.id
	AND B.name = @Columna
	ORDER BY A.xtype,A.name

GO