Skip to content

Instantly share code, notes, and snippets.

@netsi1964
Created June 27, 2012 11:10
Show Gist options
  • Save netsi1964/3003397 to your computer and use it in GitHub Desktop.
Save netsi1964/3003397 to your computer and use it in GitHub Desktop.
Dynamicweb: Find columns in table
SELECT [name] AS [Column Name]
FROM syscolumns
WHERE id = (SELECT id FROM sysobjects WHERE [Name] = 'page')
AccessUserID
AccessUserParentID
AccessUserUserName
AccessUserPassword
AccessUserName
AccessUserDepartment
AccessUserEmail
AccessUserPhone
AccessUserFax
AccessUserGroups
AccessUserType
AccessUserValidFrom
AccessUserValidTo
AccessUserPages
AccessUserAreas
AccessUserSettings
AccessUserModules
AccessUserInformation
AccessUserMyFolder
AccessUserAddress
AccessUserAddress2
AccessUserZip
AccessUserCity
AccessUserCountry
AccessUserJobTitle
AccessUserCompany
AccessUserPhonePriv
AccessUserMobile
AccessUserCustomerNumber
AccessUserRedirectOnLogin
AccessUserCurrencyCharacter
AccessUserRead
AccessUserAdsiMap
AccessUserPasswordDate
AccessUserLastName
AccessUserMiddleName
AccessUserActive
AccessUserImage
AccessUserBusiness
AccessUserInitials
AccessUserComment
AccessUserLevel
AccessUserInheritAddress
AccessUserWeb
AccessUserSort
AccessUserStatus
AccessUserStatusBegin
AccessUserStatusEnd
AccessUserStatusComment
AccessUserEditorConfigurationID
AccessUserHideStat
AccessUserCartID
AccessUserShopID
AccessUserAllowBackend
AccessUserApprovalKey
AccessUserIsConvertedByWizard
AccessUserExternalID
AccessUserSortXML
DWIntegrationDelete
Imported
ImportedGroups
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment