遍历表中的字段属性

IF OBJECT_ID('SP_LISTCOLUMNS', 'PROCEDURE') IS NOT NULL
        DROP PROC SP_LISTCOLUMNS
GO

CREATE PROC SP_LISTCOLUMNS
(
      @TABLE_NAME     NVARCHAR(50)
)
AS
BEGIN
  SELECT
       FIELDNAME = SYS.COLUMNS.NAME ,
       TYPENAME = SYS.TYPES.NAME ,
       MAX_LENGTH = SYS.COLUMNS.MAX_LENGTH,
       PREC = SYS.COLUMNS.PRECISION
   FROM sys.columns LEFT JOIN SYS.TYPES
            ON SYS.COLUMNS.SYSTEM_TYPE_ID = SYS.TYPES.SYSTEM_TYPE_ID
   LEFT JOIN SYS.SYSOBJECTS
           ON sys.columns.OBJECT_ID = SYS.SYSOBJECTS.ID
  WHERE SYS.SYSOBJECTS.XTYPE='U' AND SYS.SYSOBJECTS.NAME=@TABLE_NAME
END