USE [financials] GO /****** Object: Table [dbo].[assetallocation] Script Date: 12/30/2013 9:55:45 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[assetallocation]( [accountname] [varchar](50) NULL, [fundtype] [varchar](50) NULL, [balance] [decimal](18, 0) NULL, [accountid] [varchar](50) NULL, [fundname] [varchar](50) NULL, [year] [varchar](4) NULL, [allocation] [int] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO