Constancia icon

SQL_PROC_SYS_Tablas_Campo

Constancia | PRO | 07/12/15 07:40:28 AM UTC | 0 ⭐ | 4235 👁️ | Never ⏰ | []
PL/SQL |

550 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
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

Comments

  • icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
    
    

    

            
    •