遍历表中的字段属性

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