This was generated by TDM doing a syncronize, generate alter scripts:
CREATE TABLE [dfsi].[_FSIQueries]
(
[QueryID] Int IDENTITY(1,1) NOT NULL,
[QueryID] Int IDENTITY(1,1) NOT NULL,
[QuerySqlName] Sysname NOT NULL,
[QuerySqlName] Sysname NOT NULL,
[QuerySqlSchema] Sysname NOT NULL,
[QuerySqlSchema] Sysname NOT NULL,
[QueryFriendlyName] Varchar(100) NOT NULL,
[QueryFriendlyName] Varchar(100) NOT NULL,
[QueryIsEnabled] Bit NOT NULL,
[QueryIsEnabled] Bit NOT NULL,
[CreatedDateTime] Datetime CONSTRAINT [_FSIQueriesCrtDt] DEFAULT (getdate()) NOT NULL,
[CreatedDateTime] Datetime CONSTRAINT [_FSIQueriesCrtDt] DEFAULT (getdate()) NOT NULL,
[LastModifiedDateTime] Datetime NOT NULL,
[LastModifiedDateTime] Datetime NOT NULL,
[CreatedUserName] Varchar(100) CONSTRAINT [FSIQueriesCrtUname] DEFAULT ((suser_sname()+’’)+host_name()) NOT NULL,
[CreatedUserName] Varchar(100) CONSTRAINT [FSIQueriesCrtUname] DEFAULT ((suser_sname()+’’)+host_name()) NOT NULL,
[QueryHelp] Varchar(1000) NULL,
[QueryHelp] Varchar(1000) NULL
)