SQL_PROC_SYS_Tablas_Campo

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