Metadata DATABASEPROPERTYEX SQL function
1. Usage of DATABASEPROPERTYEX
SQL Server Query 1
SELECT
DATABASEPROPERTYEX('Northwind','Collation') AS Collation,
DATABASEPROPERTYEX('Northwind','ComparisonStyleEdition') AS ComparisonStyleEdition,
DATABASEPROPERTYEX('Northwind','IsAnsiNullDefault') AS IsAnsiNullDefault,
DATABASEPROPERTYEX('Northwind','IsAnsiNullsEnabled') AS IsAnsiNullsEnabled,
DATABASEPROPERTYEX('Northwind','IsAnsiPaddingEnabled') AS IsAnsiPaddingEnabled,
DATABASEPROPERTYEX('Northwind','IsAnsiWarningsEnabled') AS IsAnsiWarningsEnabled,
DATABASEPROPERTYEX('Northwind','IsArithmeticAbortEnabled') AS IsArithmeticAbortEnabled,
DATABASEPROPERTYEX('Northwind','IsAutoClose') AS IsAutoClose,
DATABASEPROPERTYEX('Northwind','IsAutoCreateStatistics') AS IsAutoCreateStatistics,
DATABASEPROPERTYEX('Northwind','IsAutoCreateStatisticsIncremental') AS IsAutoCreateStatisticsIncremental,
DATABASEPROPERTYEX('Northwind','IsAutoShrink') AS IsAutoShrink,
DATABASEPROPERTYEX('Northwind','IsAutoUpdateStatistics') AS IsAutoUpdateStatistics,
DATABASEPROPERTYEX('Northwind','IsClone') AS IsClone,
DATABASEPROPERTYEX('Northwind','IsCloseCursorsOnCommitEnabled') AS IsCloseCursorsOnCommitEnabled,
DATABASEPROPERTYEX('Northwind','IsDatabaseSuspendedForSnapshotBackup') AS IsDatabaseSuspendedForSnapshotBackup,
DATABASEPROPERTYEX('Northwind','IsFulltextEnabled') AS IsFulltextEnabled,
DATABASEPROPERTYEX('Northwind','IsInStandBy') AS IsInStandBy,
DATABASEPROPERTYEX('Northwind','IsLocalCursorsDefault') AS IsLocalCursorsDefault,
DATABASEPROPERTYEX('Northwind','IsMemoryOptimizedElevateToSnapshotEnabled') AS IsMemoryOptimizedElevateToSnapshotEnabled,
DATABASEPROPERTYEX('Northwind','IsMergePublished') AS IsMergePublished,
DATABASEPROPERTYEX('Northwind','IsNullConcat') AS IsNullConcat,
DATABASEPROPERTYEX('Northwind','IsNumericRoundAbortEnabled') AS IsNumericRoundAbortEnabled,
DATABASEPROPERTYEX('Northwind','IsParameterizationForced') AS IsParameterizationForced,
DATABASEPROPERTYEX('Northwind','IsQuotedIdentifiersEnabled') AS IsQuotedIdentifiersEnabled,
DATABASEPROPERTYEX('Northwind','IsPublished') AS IsPublished,
DATABASEPROPERTYEX('Northwind','IsRecursiveTriggersEnabled') AS IsRecursiveTriggersEnabled,
DATABASEPROPERTYEX('Northwind','IsSubscribed') AS IsSubscribed,
DATABASEPROPERTYEX('Northwind','IsSyncWithBackup') AS IsSyncWithBackup,
DATABASEPROPERTYEX('Northwind','IsTornPageDetectionEnabled') AS IsTornPageDetectionEnabled,
DATABASEPROPERTYEX('Northwind','IsVerifiedClone') AS IsVerifiedClone,
DATABASEPROPERTYEX('Northwind','IsXTPSupported') AS IsXTPSupported,
DATABASEPROPERTYEX('Northwind','LastGoodCheckDbTimeLCID') AS LastGoodCheckDbTimeLCID,
DATABASEPROPERTYEX('Northwind','MaxSizeInBytes') AS MaxSizeInBytes,
DATABASEPROPERTYEX('Northwind','Recovery') AS Recovery,
DATABASEPROPERTYEX('Northwind','ServiceObjective') AS ServiceObjective,
DATABASEPROPERTYEX('Northwind','ServiceObjectiveId') AS ServiceObjectiveId,
DATABASEPROPERTYEX('Northwind','SQLSortOrder') AS SQLSortOrder,
DATABASEPROPERTYEX('Northwind','Status') AS Status,
DATABASEPROPERTYEX('Northwind','Updateability') AS Updateability,
DATABASEPROPERTYEX('Northwind','UserAccess') AS UserAccess,
DATABASEPROPERTYEX('Northwind','Version') AS Version,
DATABASEPROPERTYEX('Northwind','ReplicaID') AS ReplicaID
Create SQL query with SqlQueryBuilder 1
var (sql1, parameters1) = new SqlQueryBuilder()
.Select()
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.Collation), "Collation")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.ComparisonStyleEdition), "ComparisonStyleEdition")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsAnsiNullDefault), "IsAnsiNullDefault")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsAnsiNullsEnabled), "IsAnsiNullsEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsAnsiPaddingEnabled), "IsAnsiPaddingEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsAnsiWarningsEnabled), "IsAnsiWarningsEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsArithmeticAbortEnabled), "IsArithmeticAbortEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsAutoClose), "IsAutoClose")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsAutoCreateStatistics), "IsAutoCreateStatistics")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsAutoCreateStatisticsIncremental), "IsAutoCreateStatisticsIncremental")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsAutoShrink), "IsAutoShrink")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsAutoUpdateStatistics), "IsAutoUpdateStatistics")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsClone), "IsClone")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsCloseCursorsOnCommitEnabled), "IsCloseCursorsOnCommitEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsDatabaseSuspendedForSnapshotBackup), "IsDatabaseSuspendedForSnapshotBackup")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsFulltextEnabled), "IsFulltextEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsInStandBy), "IsInStandBy")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsLocalCursorsDefault), "IsLocalCursorsDefault")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsMemoryOptimizedElevateToSnapshotEnabled), "IsMemoryOptimizedElevateToSnapshotEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsMergePublished), "IsMergePublished")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsNullConcat), "IsNullConcat")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsNumericRoundAbortEnabled), "IsNumericRoundAbortEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsParameterizationForced), "IsParameterizationForced")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsQuotedIdentifiersEnabled), "IsQuotedIdentifiersEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsPublished), "IsPublished")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsRecursiveTriggersEnabled), "IsRecursiveTriggersEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsSubscribed), "IsSubscribed")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsSyncWithBackup), "IsSyncWithBackup")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsTornPageDetectionEnabled), "IsTornPageDetectionEnabled")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsVerifiedClone), "IsVerifiedClone")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.IsXTPSupported), "IsXTPSupported")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.LastGoodCheckDbTimeLCID), "LastGoodCheckDbTimeLCID")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.MaxSizeInBytes), "MaxSizeInBytes")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.Recovery), "Recovery")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.ServiceObjective), "ServiceObjective")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.ServiceObjectiveId), "ServiceObjectiveId")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.SQLSortOrder), "SQLSortOrder")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.Status), "Status")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.Updateability), "Updateability")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.UserAccess), "UserAccess")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.Version), "Version")
.Column(new DATABASEPROPERTYEX("Northwind", DatabaseProperty.ReplicaID), "ReplicaID")
.Build();
Query build by SqlQueryBuilder 1
SELECT DATABASEPROPERTYEX(@pMAIN_2606220302247764070, @pMAIN_2606220302247764071) AS Collation,
DATABASEPROPERTYEX(@pMAIN_2606220302247764072, @pMAIN_2606220302247764073) AS ComparisonStyleEdition,
DATABASEPROPERTYEX(@pMAIN_2606220302247764074, @pMAIN_2606220302247764075) AS IsAnsiNullDefault,
DATABASEPROPERTYEX(@pMAIN_2606220302247764076, @pMAIN_2606220302247764077) AS IsAnsiNullsEnabled,
DATABASEPROPERTYEX(@pMAIN_2606220302247764078, @pMAIN_2606220302247764079) AS IsAnsiPaddingEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_10, @pMAIN_260622030224776407_11) AS IsAnsiWarningsEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_12, @pMAIN_260622030224776407_13) AS IsArithmeticAbortEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_14, @pMAIN_260622030224776407_15) AS IsAutoClose,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_16, @pMAIN_260622030224776407_17) AS IsAutoCreateStatistics,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_18, @pMAIN_260622030224776407_19) AS IsAutoCreateStatisticsIncremental,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_20, @pMAIN_260622030224776407_21) AS IsAutoShrink,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_22, @pMAIN_260622030224776407_23) AS IsAutoUpdateStatistics,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_24, @pMAIN_260622030224776407_25) AS IsClone,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_26, @pMAIN_260622030224776407_27) AS IsCloseCursorsOnCommitEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_28, @pMAIN_260622030224776407_29) AS IsDatabaseSuspendedForSnapshotBackup,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_30, @pMAIN_260622030224776407_31) AS IsFulltextEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_32, @pMAIN_260622030224776407_33) AS IsInStandBy,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_34, @pMAIN_260622030224776407_35) AS IsLocalCursorsDefault,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_36, @pMAIN_260622030224776407_37) AS IsMemoryOptimizedElevateToSnapshotEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_38, @pMAIN_260622030224776407_39) AS IsMergePublished,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_40, @pMAIN_260622030224776407_41) AS IsNullConcat,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_42, @pMAIN_260622030224776407_43) AS IsNumericRoundAbortEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_44, @pMAIN_260622030224776407_45) AS IsParameterizationForced,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_46, @pMAIN_260622030224776407_47) AS IsQuotedIdentifiersEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_48, @pMAIN_260622030224776407_49) AS IsPublished,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_50, @pMAIN_260622030224776407_51) AS IsRecursiveTriggersEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_52, @pMAIN_260622030224776407_53) AS IsSubscribed,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_54, @pMAIN_260622030224776407_55) AS IsSyncWithBackup,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_56, @pMAIN_260622030224776407_57) AS IsTornPageDetectionEnabled,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_58, @pMAIN_260622030224776407_59) AS IsVerifiedClone,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_60, @pMAIN_260622030224776407_61) AS IsXTPSupported,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_62, @pMAIN_260622030224776407_63) AS LastGoodCheckDbTimeLCID,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_64, @pMAIN_260622030224776407_65) AS MaxSizeInBytes,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_66, @pMAIN_260622030224776407_67) AS Recovery,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_68, @pMAIN_260622030224776407_69) AS ServiceObjective,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_70, @pMAIN_260622030224776407_71) AS ServiceObjectiveId,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_72, @pMAIN_260622030224776407_73) AS SQLSortOrder,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_74, @pMAIN_260622030224776407_75) AS Status,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_76, @pMAIN_260622030224776407_77) AS Updateability,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_78, @pMAIN_260622030224776407_79) AS UserAccess,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_80, @pMAIN_260622030224776407_81) AS Version,
DATABASEPROPERTYEX(@pMAIN_260622030224776407_82, @pMAIN_260622030224776407_83) AS ReplicaID;
Parameters (If used)
| Name |
Value |
| @pMAIN_2606220302247764070 |
Northwind |
| @pMAIN_2606220302247764071 |
Collation |
| @pMAIN_2606220302247764072 |
Northwind |
| @pMAIN_2606220302247764073 |
ComparisonStyleEdition |
| @pMAIN_2606220302247764074 |
Northwind |
| @pMAIN_2606220302247764075 |
IsAnsiNullDefault |
| @pMAIN_2606220302247764076 |
Northwind |
| @pMAIN_2606220302247764077 |
IsAnsiNullsEnabled |
| @pMAIN_2606220302247764078 |
Northwind |
| @pMAIN_2606220302247764079 |
IsAnsiPaddingEnabled |
| @pMAIN_260622030224776407_10 |
Northwind |
| @pMAIN_260622030224776407_11 |
IsAnsiWarningsEnabled |
| @pMAIN_260622030224776407_12 |
Northwind |
| @pMAIN_260622030224776407_13 |
IsArithmeticAbortEnabled |
| @pMAIN_260622030224776407_14 |
Northwind |
| @pMAIN_260622030224776407_15 |
IsAutoClose |
| @pMAIN_260622030224776407_16 |
Northwind |
| @pMAIN_260622030224776407_17 |
IsAutoCreateStatistics |
| @pMAIN_260622030224776407_18 |
Northwind |
| @pMAIN_260622030224776407_19 |
IsAutoCreateStatisticsIncremental |
| @pMAIN_260622030224776407_20 |
Northwind |
| @pMAIN_260622030224776407_21 |
IsAutoShrink |
| @pMAIN_260622030224776407_22 |
Northwind |
| @pMAIN_260622030224776407_23 |
IsAutoUpdateStatistics |
| @pMAIN_260622030224776407_24 |
Northwind |
| @pMAIN_260622030224776407_25 |
IsClone |
| @pMAIN_260622030224776407_26 |
Northwind |
| @pMAIN_260622030224776407_27 |
IsCloseCursorsOnCommitEnabled |
| @pMAIN_260622030224776407_28 |
Northwind |
| @pMAIN_260622030224776407_29 |
IsDatabaseSuspendedForSnapshotBackup |
| @pMAIN_260622030224776407_30 |
Northwind |
| @pMAIN_260622030224776407_31 |
IsFulltextEnabled |
| @pMAIN_260622030224776407_32 |
Northwind |
| @pMAIN_260622030224776407_33 |
IsInStandBy |
| @pMAIN_260622030224776407_34 |
Northwind |
| @pMAIN_260622030224776407_35 |
IsLocalCursorsDefault |
| @pMAIN_260622030224776407_36 |
Northwind |
| @pMAIN_260622030224776407_37 |
IsMemoryOptimizedElevateToSnapshotEnabled |
| @pMAIN_260622030224776407_38 |
Northwind |
| @pMAIN_260622030224776407_39 |
IsMergePublished |
| @pMAIN_260622030224776407_40 |
Northwind |
| @pMAIN_260622030224776407_41 |
IsNullConcat |
| @pMAIN_260622030224776407_42 |
Northwind |
| @pMAIN_260622030224776407_43 |
IsNumericRoundAbortEnabled |
| @pMAIN_260622030224776407_44 |
Northwind |
| @pMAIN_260622030224776407_45 |
IsParameterizationForced |
| @pMAIN_260622030224776407_46 |
Northwind |
| @pMAIN_260622030224776407_47 |
IsQuotedIdentifiersEnabled |
| @pMAIN_260622030224776407_48 |
Northwind |
| @pMAIN_260622030224776407_49 |
IsPublished |
| @pMAIN_260622030224776407_50 |
Northwind |
| @pMAIN_260622030224776407_51 |
IsRecursiveTriggersEnabled |
| @pMAIN_260622030224776407_52 |
Northwind |
| @pMAIN_260622030224776407_53 |
IsSubscribed |
| @pMAIN_260622030224776407_54 |
Northwind |
| @pMAIN_260622030224776407_55 |
IsSyncWithBackup |
| @pMAIN_260622030224776407_56 |
Northwind |
| @pMAIN_260622030224776407_57 |
IsTornPageDetectionEnabled |
| @pMAIN_260622030224776407_58 |
Northwind |
| @pMAIN_260622030224776407_59 |
IsVerifiedClone |
| @pMAIN_260622030224776407_60 |
Northwind |
| @pMAIN_260622030224776407_61 |
IsXTPSupported |
| @pMAIN_260622030224776407_62 |
Northwind |
| @pMAIN_260622030224776407_63 |
LastGoodCheckDbTimeLCID |
| @pMAIN_260622030224776407_64 |
Northwind |
| @pMAIN_260622030224776407_65 |
MaxSizeInBytes |
| @pMAIN_260622030224776407_66 |
Northwind |
| @pMAIN_260622030224776407_67 |
Recovery |
| @pMAIN_260622030224776407_68 |
Northwind |
| @pMAIN_260622030224776407_69 |
ServiceObjective |
| @pMAIN_260622030224776407_70 |
Northwind |
| @pMAIN_260622030224776407_71 |
ServiceObjectiveId |
| @pMAIN_260622030224776407_72 |
Northwind |
| @pMAIN_260622030224776407_73 |
SQLSortOrder |
| @pMAIN_260622030224776407_74 |
Northwind |
| @pMAIN_260622030224776407_75 |
Status |
| @pMAIN_260622030224776407_76 |
Northwind |
| @pMAIN_260622030224776407_77 |
Updateability |
| @pMAIN_260622030224776407_78 |
Northwind |
| @pMAIN_260622030224776407_79 |
UserAccess |
| @pMAIN_260622030224776407_80 |
Northwind |
| @pMAIN_260622030224776407_81 |
Version |
| @pMAIN_260622030224776407_82 |
Northwind |
| @pMAIN_260622030224776407_83 |
ReplicaID |
Query Results 1:
| |
Collation |
ComparisonStyleEdition |
IsAnsiNullDefault |
IsAnsiNullsEnabled |
IsAnsiPaddingEnabled |
IsAnsiWarningsEnabled |
IsArithmeticAbortEnabled |
IsAutoClose |
IsAutoCreateStatistics |
IsAutoCreateStatisticsIncremental |
IsAutoShrink |
IsAutoUpdateStatistics |
IsClone |
IsCloseCursorsOnCommitEnabled |
IsDatabaseSuspendedForSnapshotBackup |
IsFulltextEnabled |
IsInStandBy |
IsLocalCursorsDefault |
IsMemoryOptimizedElevateToSnapshotEnabled |
IsMergePublished |
IsNullConcat |
IsNumericRoundAbortEnabled |
IsParameterizationForced |
IsQuotedIdentifiersEnabled |
IsPublished |
IsRecursiveTriggersEnabled |
IsSubscribed |
IsSyncWithBackup |
IsTornPageDetectionEnabled |
IsVerifiedClone |
IsXTPSupported |
LastGoodCheckDbTimeLCID |
MaxSizeInBytes |
Recovery |
ServiceObjective |
ServiceObjectiveId |
SQLSortOrder |
Status |
Updateability |
UserAccess |
Version |
ReplicaID |
| 1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|