V_ALLCMSCONTENTTYPES
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | int | ||
| Name | nvarchar(141) | yes | |
| DesktopSrc | nvarchar(256) | ||
| EditControl | nvarchar(256) | yes | |
| ClassName | nvarchar(256) | yes | |
| Static | bit | ||
| RequiresSSL | bit | yes | |
| Custom | bit | yes | |
| CustomPD | bit | ||
| UniqueContent | bit | ||
| CanCopy | bit | ||
| RealmTypeId | int | ||
| VersioningSupported | bit | ||
| Hidden | bit | ||
| Deprecated | bit | ||
| Description | nvarchar(500) | yes | |
| SupportsLimitedConnectivity | bit | yes | |
| Flag | nvarchar(50) | yes | |
| CanShare | bit | ||
| CanUpdate | bit |
Definition
Copy
create view [dbo].[V_ALLCMSCONTENTTYPES]
as
select
ct.[ID],
CASE ct.[Deprecated]
WHEN 0 THEN ct.[Name]
WHEN 1 THEN ct.[Name] + ' (Deprecated)'
END As [Name],
ct.[DesktopSrc],
ct.[EditControl],
ct.[ClassName],
ct.[Static],
ct.[RequiresSSL],
ct.[Custom],
ct.[CustomPD],
ct.[UniqueContent],
(ct.[CanCopy] & ~ct.[Deprecated]) As [CanCopy],
ct.[RealmTypeId],
ct.[VersioningSupported],
ct.[Hidden],
ct.[Deprecated],
ct.[Description],
ct.[SupportsLimitedConnectivity],
dbo.fnFlag(ct.[Flag], ct.[ID]) AS [Flag],
ct.CanShare,
ct.CanUpdate
from
[dbo].[ContentTypes] ct