Generated Select All statements ( see the previous post )

-- START ===== CAS_DEV.dbo.AlVersionLog.SelectAll.Script.sql

SELECT [AlVersionLogId] , [MajorReleaseNumber] , [MinorReleaseNumber] , [PointReleaseNumber] , [LastCodeUnitName] , [VersionNumber] , [AffectedAlObjNames] , [Author] , [Description] FROM CAS_DEV.dbo.[AlVersionLog] ;

-- END ================== CAS_DEV.dbo.AlVersionLog.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.AppName.SelectAll.Script.sql

SELECT [AppNameId] , [Name] , [DisplayName] , [Description] , [AlNameId] , [DbNameId] FROM CAS_DEV.dbo.[AppName] ;

-- END ================== CAS_DEV.dbo.AppName.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.AppSettings.SelectAll.Script.sql

SELECT [AppSettingsId] , [AlNameId] , [CultureInfo] , [LangInfoId] , [CurrencyDecimalDigits] , [FlagEncryptErrorMessages] , [GuiLanguage] , [GuiTracking] , [LogLevel] , [LogOutput] , [NumberDecimalDigits] , [NumberDecimalSeparator] , [NumberGroupSeparator] , [FlagShowDbSwitcher] , [ConnectionStringTemplate] , [DbHostNameAndInstance] , [DefaultDb] , [AppLoginName] , [AppLoginPass] , [DefaultLoginName] , [DefaultLoginPass] , [DefaultRDBMS] , [ServerDNSName] , [ColorNeutralHexVal] , [ColorNokHexVal] , [ColorOkHexVal] , [NumberOfDatabases] , [CultureNameUnderscored] , [EncryptionAlgorithm] , [AppThemeId] , [AppPort] , [UseDNSRemapping] , [UseSecureConnection] , [AppPortForLinkGeneraton] , [DebugDir] FROM CAS_DEV.dbo.[AppSettings] ;

-- END ================== CAS_DEV.dbo.AppSettings.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.AppTheme.SelectAll.Script.sql

SELECT [AppThemeId] , [Name] , [Description] FROM CAS_DEV.dbo.[AppTheme] ;

-- END ================== CAS_DEV.dbo.AppTheme.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.BaseType.SelectAll.Script.sql

SELECT [BaseTypeId] , [BaseTypeName] , [BaseTypeDescription] FROM CAS_DEV.dbo.[BaseType] ;

-- END ================== CAS_DEV.dbo.BaseType.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Bug.SelectAll.Script.sql

SELECT [BugId] , [Name] , [Description] , [Comment] , [Priority] , [StatusId] , [DetectedBy] , [AssignedTo] FROM CAS_DEV.dbo.[Bug] ;

-- END ================== CAS_DEV.dbo.Bug.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.BugHistory.SelectAll.Script.sql

SELECT [BugHistoryId] , [BugId] , [Name] , [Description] , [Comment] , [Priority] , [StatusId] , [DetectedBy] , [AssignedTo] , [SqlLogin] , [Action] , [UpdatedWhen] FROM CAS_DEV.dbo.[BugHistory] ;

-- END ================== CAS_DEV.dbo.BugHistory.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.ClassLog.SelectAll.Script.sql

SELECT [ClassLogId] , [ClassName] , [ObjName] , [MethodName] , [LineNumber] , [Time] , [NiceTime] , [SqlLogin] , [DomainName] , [Msg] , [DebugMsg] FROM CAS_DEV.dbo.[ClassLog] ;

-- END ================== CAS_DEV.dbo.ClassLog.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Comment.SelectAll.Script.sql

SELECT [CommentId] , [PageId] , [UserId] , [CommmentedItemId] , [Title] , [Content] , [TimeOfComment] , [MetaTableId] , [MetaTableName] FROM CAS_DEV.dbo.[Comment] ;

-- END ================== CAS_DEV.dbo.Comment.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.ControlType.SelectAll.Script.sql

SELECT [ControlTypeId] , [Name] , [Title] , [Description] , [TitleMsgKey] FROM CAS_DEV.dbo.[ControlType] ;

-- END ================== CAS_DEV.dbo.ControlType.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.DbVersionLog.SelectAll.Script.sql

SELECT [DbVersionLogId] , [MajorReleaseNumber] , [MinorReleaseNumber] , [PointReleaseNumber] , [LastCodeUnitName] , [VersionNumber] , [AffectedDbObjName] , [Description] FROM CAS_DEV.dbo.[DbVersionLog] ;

-- END ================== CAS_DEV.dbo.DbVersionLog.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.DbVsCSharpTypes.SelectAll.Script.sql

SELECT [DbVsCSharpTypesId] , [Sql2008DataType] , [CSharpDataType] , [CLRDataType] , [CLRDataTypeSqlServer] , [CSharpConvertToCode] FROM CAS_DEV.dbo.[DbVsCSharpTypes] ;

-- END ================== CAS_DEV.dbo.DbVsCSharpTypes.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.DdlLog.SelectAll.Script.sql

SELECT [LogId] , [DatabaseName] , [EventType] , [ObjectName] , [ObjectType] , [SqlCommand] , [EventDate] , [LoginName] FROM CAS_DEV.dbo.[DdlLog] ;

-- END ================== CAS_DEV.dbo.DdlLog.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.DebugLog.SelectAll.Script.sql

SELECT [DebugLogId] , [TimeStamp] , [Time] , [NiceTime] , [Domain_User] , [Msg] , [LogLevel] , [DebugMsg] , [PageURL] , [ClassName] , [MethodName] , [MethodNameGui] , [Ret] , [LineNumber] , [ProcedureName] , [ProcedureStep] , [AlNameId] , [DbNameId] , [UserSessionId] , [PageTypeId] FROM CAS_DEV.dbo.[DebugLog] ;

-- END ================== CAS_DEV.dbo.DebugLog.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Definition.SelectAll.Script.sql

SELECT [DefinitionId] , [Abbreviation] , [Name] , [Description] FROM CAS_DEV.dbo.[Definition] ;

-- END ================== CAS_DEV.dbo.Definition.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.DestinationTable.SelectAll.Script.sql

SELECT [ID] , [RandomNumber] FROM CAS_DEV.dbo.[DestinationTable] ;

-- END ================== CAS_DEV.dbo.DestinationTable.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.DuplicatesTable.SelectAll.Script.sql

SELECT [ColA] , [ColB] , [DuplicatesTableId] FROM CAS_DEV.dbo.[DuplicatesTable] ;

-- END ================== CAS_DEV.dbo.DuplicatesTable.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Form.SelectAll.Script.sql

SELECT [FormId] , [FormTypeId] , [Name] , [CanvasControlId] , [Title] , [StoredProc] FROM CAS_DEV.dbo.[Form] ;

-- END ================== CAS_DEV.dbo.Form.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.FormType.SelectAll.Script.sql

SELECT [FormTypeId] , [Name] , [Description] FROM CAS_DEV.dbo.[FormType] ;

-- END ================== CAS_DEV.dbo.FormType.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Idea.SelectAll.Script.sql

SELECT [IdeaId] , [Name] , [Title] , [Description] , [CreatedBy] , [TotalVotes] FROM CAS_DEV.dbo.[Idea] ;

-- END ================== CAS_DEV.dbo.Idea.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.IncidentType.SelectAll.Script.sql

SELECT [IncidentTypeId] , [Name] , [Description] FROM CAS_DEV.dbo.[IncidentType] ;

-- END ================== CAS_DEV.dbo.IncidentType.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.LangInfo.SelectAll.Script.sql

SELECT [LangInfoId] , [CultureName] , [DisplayName] , [ISO_639x_Value] , [CultureCode] , [CollationName] , [IsEnabledInApp] , [CultureNameU] FROM CAS_DEV.dbo.[LangInfo] ;

-- END ================== CAS_DEV.dbo.LangInfo.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Listing.SelectAll.Script.sql

SELECT [ListingId] , [ListingTypeId] , [Name] , [CanvasControlId] , [Title] , [StoredProc] FROM CAS_DEV.dbo.[Listing] ;

-- END ================== CAS_DEV.dbo.Listing.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.ListingType.SelectAll.Script.sql

SELECT [ListingTypeId] , [Name] , [Title] , [Description] FROM CAS_DEV.dbo.[ListingType] ;

-- END ================== CAS_DEV.dbo.ListingType.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.LogLevel.SelectAll.Script.sql

SELECT [LogLevelId] , [Name] , [Description] , [DbName] FROM CAS_DEV.dbo.[LogLevel] ;

-- END ================== CAS_DEV.dbo.LogLevel.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.MetaParameter.SelectAll.Script.sql

SELECT [MetaParameterId] , [ProcName] , [FormId] , [ParamName] , [DataType] , [MaxLength] , [IsNullable] , [IsResult] , [IsDefaultApi] , [ParameterMode] , [ControlTypeId] , [ProcPopulator] , [TableNameForDropDown] , [ColumnNameForDropDown] , [ProcAcceptor] , [ProcItemValSelectForDdl] , [Title] , [ToolTip] , [FieldSet] , [FieldSetTitle] , [ControlLength] , [ControlHeight] , [IsReadOnly] , [IsVisible] , [NumberDecimalDigits] , [CurrencyDecimalDigits] , [NumberGroupSeparator] , [NumberDecimalSeparator] , [TitleLabelCssClass] , [ContainerCssClass] , [ContainerCssStyleKeys] , [ContainerCssStyleVals] , [CssClass] , [TitleLabelCssStyleKeys] , [CssStyleKeys] , [TitleLabelCssStyleVals] , [CssStyleVals] , [IsDeleted] , [GuiOrder] , [HasPostBackEvent] FROM CAS_DEV.dbo.[MetaParameter] ;

-- END ================== CAS_DEV.dbo.MetaParameter.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.MetaPkFkRelations.SelectAll.Script.sql

SELECT [MetaPkFkRelationsId] , [FkTable] , [FkName] , [FkColName] , [PkTable] , [PKColName] , [OnDeleteCascate] , [OnUpdateCascade] FROM CAS_DEV.dbo.[MetaPkFkRelations] ;

-- END ================== CAS_DEV.dbo.MetaPkFkRelations.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.MetaStoredProcedure.SelectAll.Script.sql

SELECT [MetaStoredProcedureId] , [DbName] , [SchemaName] , [Name] , [Title] , [DocumentationDescription] , [IsPlatform] , [IsDeleted] , [CreationOrder] FROM CAS_DEV.dbo.[MetaStoredProcedure] ;

-- END ================== CAS_DEV.dbo.MetaStoredProcedure.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.MetaTable.SelectAll.Script.sql

SELECT [MetaTableId] , [DbName] , [SchemaName] , [Name] , [Title] , [Documentation] , [DocForLastEdit] , [UserIdLastEditor] , [IsPlatform] , [IsDeleted] , [CreationOrder] FROM CAS_DEV.dbo.[MetaTable] ;

-- END ================== CAS_DEV.dbo.MetaTable.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.MetaTableHistory.SelectAll.Script.sql

SELECT [MetaTableHistoryId] , [MetaTableId] , [DbName] , [SchemaName] , [Name] , [Title] , [Documentation] , [DocForLastEdit] , [IsPlatform] , [IsDeleted] , [CreationOrder] , [SqlLogin] , [Action] , [UpdatedWhen] FROM CAS_DEV.dbo.[MetaTableHistory] ;

-- END ================== CAS_DEV.dbo.MetaTableHistory.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.MetaTableStatus.SelectAll.Script.sql

SELECT [MetaTableStatusId] , [MetaTableId] , [StatusId] FROM CAS_DEV.dbo.[MetaTableStatus] ;

-- END ================== CAS_DEV.dbo.MetaTableStatus.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.NamingConvention.SelectAll.Script.sql

SELECT [NamingConventionId] , [Name] , [Rule] , [Description] FROM CAS_DEV.dbo.[NamingConvention] ;

-- END ================== CAS_DEV.dbo.NamingConvention.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.NonDuplicatesTable.SelectAll.Script.sql

SELECT [ColA] , [ColB] FROM CAS_DEV.dbo.[NonDuplicatesTable] ;

-- END ================== CAS_DEV.dbo.NonDuplicatesTable.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Page.SelectAll.Script.sql

SELECT [PageId] , [PageTypeId] , [Title] , [URL] , [LinkToolTip] , [CanvasControlId] , [AppThemeId] , [PageControlsId] , [MaintainScrollPositionOnPostBack] , [FlagNeedsAuthentication] FROM CAS_DEV.dbo.[Page] ;

-- END ================== CAS_DEV.dbo.Page.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.PageForm.SelectAll.Script.sql

SELECT [PageFormKey] , [PageKey] , [FormKey] FROM CAS_DEV.dbo.[PageForm] ;

-- END ================== CAS_DEV.dbo.PageForm.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.PageListing.SelectAll.Script.sql

SELECT [PageListingId] , [PageKey] , [ListingKey] FROM CAS_DEV.dbo.[PageListing] ;

-- END ================== CAS_DEV.dbo.PageListing.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.PageType.SelectAll.Script.sql

SELECT [PageTypeId] , [Name] , [Description] , [MetaTableId] , [MetaTableName] FROM CAS_DEV.dbo.[PageType] ;

-- END ================== CAS_DEV.dbo.PageType.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Permissions.SelectAll.Script.sql

SELECT [PermissionsId] , [principle_name] , [principle_type_desc] , [object_name] , [permission_name] , [permission_state_desc] FROM CAS_DEV.dbo.[Permissions] ;

-- END ================== CAS_DEV.dbo.Permissions.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.PermissionStateDesc.SelectAll.Script.sql

SELECT [PermissionStateDescId] , [Name] , [DisplayName] , [Description] FROM CAS_DEV.dbo.[PermissionStateDesc] ;

-- END ================== CAS_DEV.dbo.PermissionStateDesc.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Person.SelectAll.Script.sql

SELECT [PersonId] , [FirstName] , [MiddleName] , [LastName] , [DateOfBirth] , [DateOfDead] FROM CAS_DEV.dbo.[Person] ;

-- END ================== CAS_DEV.dbo.Person.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.PlReports.SelectAll.Script.sql

SELECT [PlReportsId] , [PageId] , [StoredProcName] , [Title] , [DescriptionMsg] FROM CAS_DEV.dbo.[PlReports] ;

-- END ================== CAS_DEV.dbo.PlReports.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.PrincipleTypeDesc.SelectAll.Script.sql

SELECT [PrincipleTypeDescId] , [Name] , [DisplayName] , [Description] FROM CAS_DEV.dbo.[PrincipleTypeDesc] ;

-- END ================== CAS_DEV.dbo.PrincipleTypeDesc.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Process.SelectAll.Script.sql

SELECT [ProcessId] , [Name] , [Description] , [Comments] FROM CAS_DEV.dbo.[Process] ;

-- END ================== CAS_DEV.dbo.Process.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.ProcessStep.SelectAll.Script.sql

SELECT [ProcessStepId] , [Name] , [Description] , [Comments] FROM CAS_DEV.dbo.[ProcessStep] ;

-- END ================== CAS_DEV.dbo.ProcessStep.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.ProcLog.SelectAll.Script.sql

SELECT [ProcLogId] , [ProcName] , [ProcStep] , [Time] , [NiceTime] , [SqlLogin] , [DomainName] , [Msg] , [DebugMsg] FROM CAS_DEV.dbo.[ProcLog] ;

-- END ================== CAS_DEV.dbo.ProcLog.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.RDBMSType.SelectAll.Script.sql

SELECT [RDBMSTypeId] , [Name] , [Title] , [Description] FROM CAS_DEV.dbo.[RDBMSType] ;

-- END ================== CAS_DEV.dbo.RDBMSType.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Requirement.SelectAll.Script.sql

SELECT [RequirementId] , [Vote] , [Key] , [Title] , [Description] , [IsPlatform] , [IsInstanceApp] , [StatusId] , [RegisteredByUserId] , [CreatedByUserId] , [RegisteredWhen] , [CompletedWhen] FROM CAS_DEV.dbo.[Requirement] ;

-- END ================== CAS_DEV.dbo.Requirement.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.RequirementHistory.SelectAll.Script.sql

SELECT [RequirementHistoryId] , [RequirementId] , [Vote] , [Key] , [Title] , [Description] , [IsPlatform] , [IsInstanceApp] , [StatusId] , [RegisteredByUserId] , [CreatedByUserId] , [RegisteredWhen] , [CompletedWhen] , [SqlLogin] , [Action] , [UpdatedWhen] FROM CAS_DEV.dbo.[RequirementHistory] ;

-- END ================== CAS_DEV.dbo.RequirementHistory.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Role.SelectAll.Script.sql

SELECT [RoleId] , [Name] , [Description] FROM CAS_DEV.dbo.[Role] ;

-- END ================== CAS_DEV.dbo.Role.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.RunJobHistory.SelectAll.Script.sql

SELECT [RunJobHistoryId] , [RunStartTime] , [RunStopTime] , [ProjectName] , [TeraServerName] , [DataBaseName] , [ObjectName] , [SqlLogin] , [Passwd] , [SqlQuery] , [DeltaBeginTime] , [DeltaEndTime] , [FlagToRun] , [Remarks] FROM CAS_DEV.dbo.[RunJobHistory] ;

-- END ================== CAS_DEV.dbo.RunJobHistory.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.RunJobSchedule.SelectAll.Script.sql

SELECT [RunJobScheduleId] , [RunJobUnitId] , [DeltaBeginTime] , [DeltaEndTime] , [FlagToRun] , [Remarks] FROM CAS_DEV.dbo.[RunJobSchedule] ;

-- END ================== CAS_DEV.dbo.RunJobSchedule.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.RunJobUnit.SelectAll.Script.sql

SELECT [RunJobUnitId] , [ProjectName] , [TeraServerName] , [DataBaseName] , [ObjectName] , [SqlLogin] , [Passwd] , [SqlQuery] , [Remarks] FROM CAS_DEV.dbo.[RunJobUnit] ;

-- END ================== CAS_DEV.dbo.RunJobUnit.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.SourceTable.SelectAll.Script.sql

SELECT [ID] , [RandomNumber] FROM CAS_DEV.dbo.[SourceTable] ;

-- END ================== CAS_DEV.dbo.SourceTable.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Status.SelectAll.Script.sql

SELECT [StatusId] , [Name] , [Description] FROM CAS_DEV.dbo.[Status] ;

-- END ================== CAS_DEV.dbo.Status.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.SubType1.SelectAll.Script.sql

SELECT [SubType1Id] , [BaseTypeKey] , [Name] , [Description] FROM CAS_DEV.dbo.[SubType1] ;

-- END ================== CAS_DEV.dbo.SubType1.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.SubType2.SelectAll.Script.sql

SELECT [SubType2Id] , [BaseTypeKey] , [Name] , [Description] FROM CAS_DEV.dbo.[SubType2] ;

-- END ================== CAS_DEV.dbo.SubType2.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.SystemAccount.SelectAll.Script.sql

SELECT [SystemAccountId] , [Name] , [Description] FROM CAS_DEV.dbo.[SystemAccount] ;

-- END ================== CAS_DEV.dbo.SystemAccount.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Task.SelectAll.Script.sql

SELECT [TaskId] , [Name] , [Description] , [Priority] , [PriorityId] , [StatusId] , [AssignedTo] , [CreatedBy] , [Deadline] , [Weekday] , [TimeEstimate] , [TimeActual] , [RegistrationDate] , [Comments] FROM CAS_DEV.dbo.[Task] ;

-- END ================== CAS_DEV.dbo.Task.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.TbGuiTabWizard.SelectAll.Script.sql

SELECT [TbGuiTabWizardId] , [TabId] , [PageInstanceId] , [WizardId] , [TabOrder] , [TabTitle] , [TabHasManyButtons] , [ButtonTitle] , [Description] , [ProcToStart] , [ProcId] , [ItemMetaId] , [ItemStartProc] , [ItemButtonToolTip] , [ItemButtonText] , [TypeOfTab] , [WizardHasStepping] , [RunProcOnTabClick] , [TabIsPRS] , [ItemIsPRS] , [FlagPresentAreYouSurePrompt] , [PromptAreYouSureText] , [PageId] , [Menuid] FROM CAS_DEV.dbo.[TbGuiTabWizard] ;

-- END ================== CAS_DEV.dbo.TbGuiTabWizard.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.Test.SelectAll.Script.sql

SELECT [TestId] , [Name] , [DisplayName] , [Description] FROM CAS_DEV.dbo.[Test] ;

-- END ================== CAS_DEV.dbo.Test.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.User.SelectAll.Script.sql

SELECT [UserId] , [PersonKey] , [SystemAccountKey] , [SqlLogin] , [DomainName] , [Pass] , [DefaultRoleId] , [IsActive] FROM CAS_DEV.dbo.[User] ;

-- END ================== CAS_DEV.dbo.User.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.UserRole.SelectAll.Script.sql

SELECT [UserRoleId] , [UserKey] , [RoleKey] FROM CAS_DEV.dbo.[UserRole] ;

-- END ================== CAS_DEV.dbo.UserRole.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.UserSession.SelectAll.Script.sql

SELECT [UserSessionId] , [UserId] , [StartTime] , [EndTime] FROM CAS_DEV.dbo.[UserSession] ;

-- END ================== CAS_DEV.dbo.UserSession.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.UserSettings.SelectAll.Script.sql

SELECT [UserSettingsId] , [UserId] , [CultureInfo] , [LangInfoId] , [CurrencyDecimalDigits] , [FlagEncryptErrorMessages] , [GuiLanguage] , [GuiTracking] , [LogLevel] , [LogOutput] , [NumberDecimalDigits] , [NumberDecimalSeparator] , [NumberGroupSeparator] , [FlagShowDbSwitcher] , [ConnectionStringTemplate] , [DbHostNameAndInstance] , [DefaultDb] , [DefaultLoginName] , [DefaultLoginPass] , [DefaultRDBMS] , [ServerDNSName] , [ColorNeutralHexVal] , [ColorNokHexVal] , [ColorOkHexVal] , [NumberOfDatabases] , [CultureNameUnderscored] , [EncryptionAlgorithm] , [AppThemeId] , [DebugDir] FROM CAS_DEV.dbo.[UserSettings] ;

-- END ================== CAS_DEV.dbo.UserSettings.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.UserState.SelectAll.Script.sql

SELECT [UserStateId] , [Name] , [DisplayName] , [Description] FROM CAS_DEV.dbo.[UserState] ;

-- END ================== CAS_DEV.dbo.UserState.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.UserStory.SelectAll.Script.sql

SELECT [UserStoryId] , [Name] , [Description] , [PriorityId] , [StatusId] , [AssignedTo] , [CreatedBy] , [RegistrationDate] FROM CAS_DEV.dbo.[UserStory] ;

-- END ================== CAS_DEV.dbo.UserStory.SelectAll.Script.sql

-- START ===== CAS_DEV.dbo.viewMeta_TableColumns.SelectAll.Script.sql

SELECT [TableName] , [ColumnName] , [DataType] , [IsNullable] , [IsPrimaryKey] , [MaxLength] , [IsComputed] , [DefaultValue] FROM CAS_DEV.dbo.[viewMeta_TableColumns] ;

-- END ================== CAS_DEV.dbo.viewMeta_TableColumns.SelectAll.Script.sql