SELECT  @@Servername AS Server ,
        DB_NAME() AS DBName ,
        isc.Table_Name AS TableName ,
        isc.Table_Schema AS SchemaName ,
        Ordinal_Position AS  Ord ,
        Column_Name ,
        Data_Type ,
        Numeric_Precision AS  Prec ,
        Numeric_Scale AS  Scale ,
        Character_Maximum_Length AS LEN , -- -1 means MAX like Varchar(MAX) 
        Is_Nullable ,
        Column_Default ,
        Table_Type
FROM     INFORMATION_SCHEMA.COLUMNS isc
        INNER JOIN  information_schema.tables ist
              ON isc.table_name = ist.table_name 
--      WHERE Table_Type = 'BASE TABLE' -- 'Base Table' or 'View' 
ORDER BY DBName ,
        TableName ,
        SchemaName ,
        Ordinal_position;  

_AccumRg11943	dbo	1	_Period	datetime
_AccumRg11943	dbo	2	_RecorderTRef	binary
_AccumRg11943	dbo	3	_RecorderRRef	binary
_AccumRg11943	dbo	4	_LineNo	numeric
_AccumRg11943	dbo	5	_Active	binary
_AccumRg11943	dbo	25	_Fld620	numeric

 CREATE UNIQUE CLUSTERED INDEX [_Accum11943_ByPeriod_TRN] ON [dbo].[_AccumRg11943]
(
	[_Fld620] ASC,
	[_Period] ASC,
	[_RecorderTRef] ASC,
	[_RecorderRRef] ASC,
	[_LineNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = ON, IGNORE_DUP_KEY = OFF, DROP_EXISTING = ON, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, MAXDOP = 8, DATA_COMPRESSION = PAGE) ON [FILEGROUP]

GO