MSSQL 2000 column-level collation

[sethdarr]

Hello. I am trying to modify an existing template to generate backup scripts for individual tables in MSSQL 2000. Everything was going dandy until it came down to scripting out column-level collations. I can't seem to find any indication that the MyMeta object model has those attributes. There is a collation on indices of a table, but these tables have no indices. Can anyone point me in the right direction?

sample table i'm trying to script):

Code: Select all

CREATE TABLE [dbo].[ACCOUNT_TRANSACTION] (
   [PCO] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
   [ACCOUNT_TRAN] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [ACTN_LITERAL_DESC] [varchar] (26) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [NOTICE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [RECEIPT_TRAN] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [RCTN_LITERAL_DESC] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [RCTN_PAYMENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [ACTN_ADD] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [RCTN_ADD] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [RECORD_ID] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [ACTN_HELP_DESC] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [RCTN_HELP_DESC] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [SEQ_NUM] [int] NULL
) ON [PRIMARY]