SQL_PROC_SYS_Campos_Tabla

USE [METRICAS]
GO

--****** Object      :StoredProcedure [dbo].[PROC_SYS_Campos_Tabla]
--****** 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_Campos_Tabla]
   @Tabla VARCHAR(100)
AS

SELECT DISTINCT
syscolumns.colid AS IdCampo, syscolumns.name AS Campo, systypes.name AS Tipo,
syscolumns.LENGTH AS Longitud,
CASE
    WHEN SysColumns.isnullable = 1 THEN 'SI'
    ELSE ''
END AS Permite_Nulo,
CASE
    WHEN sysindexkeys.Keyno IS NULL THEN ''
    ELSE 'SI'
END AS Clave,
CASE
    WHEN sysforeignkeys.fkey IS NULL THEN ''
    ELSE 'SI'
END AS Clave_Externa,
CASE
    WHEN sysobjects_1.name IS NULL THEN ''
    ELSE sysobjects_1.name
END AS Tabla_Externa
FROM
sysobjects sysobjects_1 RIGHT OUTER JOIN
sysforeignkeys ON sysobjects_1.id = sysforeignkeys.rkeyid RIGHT OUTER JOIN
syscolumns INNER JOIN
sysobjects ON syscolumns.id = sysobjects.id INNER JOIN
systypes ON syscolumns.xtype = systypes.xtype ON sysforeignkeys.fkeyid = syscolumns.id AND
sysforeignkeys.fkey = syscolumns.colid LEFT OUTER JOIN
sysindexkeys ON sysobjects.id = sysindexkeys.id AND syscolumns.colid = sysindexkeys.colid
WHERE
sysobjects.name = @Tabla AND systypes.name <> 'sysname'
ORDER BY syscolumns.colid

GO