Metadata DB_NAME SQL function


1. Usage of DB_NAME

SQL Server Query 1

            
 SELECT DB_NAME() AS Current_Database  
union
SELECT DB_NAME(3) AS Current_Database

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  
.Select()
.Column(new DB_NAME(), "Current_Database")
.Union(new SqlQueryBuilder()
.Select()
.Column(new DB_NAME(3), "Current_database")
)
.Build();

Query build by SqlQueryBuilder 1

            
SELECT DB_NAME() AS Current_Database
UNION
SELECT DB_NAME(@pMAIN_2606200150422003710) AS Current_database;


            
        

Parameters (If used)

Name Value
@pMAIN_2606200150422003710 3

Query Results 1:

  Current_Database
1 model
2 TheBlueSoftDB


1. Usage of DB_NAME with sys table

SQL Server Query 2

            
 SELECT DB_NAME(database_id) AS [Database],  
Database_ID
FROM sys.databases;

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = new SqlQueryBuilder()  
.Select()
.Column(new DB_NAME(new Column("database_id")), "[Database]")
.Column("Database_ID", "Database_ID")
.From("sys.databases")
.Build();

Query build by SqlQueryBuilder 2

            
SELECT DB_NAME(database_id) AS [Database],
       Database_ID AS Database_ID
FROM sys.databases;


            
        

Parameters (If used)

Name Value

Query Results 2:

  Database Database_ID
1 aaravewm_devdb 192
2 aaravewm_maindb 191
3 Accounting 18
4 Accounts_V1 130
5 Agrena_V1 143
6 AgrenaDemo_V1 90
7 agtransport 217
8 AiaApi 204
9 AIRobot 9
10 akhandaaDB1 61
11 Amrutam_DB 135
12 APM_TEST 236
13 appointr_dbsid 281
14 appointr_demoeinv 206
15 appointr_devendra 302
16 appointr_harveer_einv 50
17 appointr_naininat 205
18 appointr_patwari 265
19 appointr_prateek 53
20 appointr_sb25 52
21 appointr_sidall 42
22 approvalrequest_db 286
23 approvalrequest_uat_db 288
24 arravbackup 176
25 attendance_MG 161
26 Attendance_V1 152
27 averysite 119
28 AvpRoyalClub 211
29 AvpSangam 219
30 avttransport 208
31 avttransportdev 215
32 axontech_ 298
33 AZWISApps 116
34 balaji_staging 238
35 BGVAppDb 243
36 biodatas_crm 167
37 bizmargcrm_db 180
38 Bnbmining_DB 186
39 bnbxnetDB 203
40 campzeo1.net 270
41 campzeo1_ 38
42 campzeo1_SVGDC_NIHRI_DB 140
43 Candidate_V1 127
44 capitallive_DB 108
45 carepointpro_Backup 34
46 CBT_V1 262
47 ccncbizdb 182
48 CefiAlumni 60
49 CefiPotal 59
50 CF_SaaS_DEV 249
51 chaipecharcha_DB 251
52 chaipecharcha_DB1 271
53 chakraai_ 153
54 charnaseva_staging 247
55 chess10025_cs_db 200
56 cmms_db 289
57 CMMS_MasGen 264
58 CMS 71
59 CMS_CBE 80
60 codefolks_CentroMallLive 89
61 communityjain_db 19
62 conferencedbv1 148
63 CRM_V2 306
64 crowdfundcrypto_db 111
65 cutango-app 166
66 db_AlSadaahSociety 250
67 Db_Bogus 297
68 DB_BUILDING_MANAGEMENT 101
69 db_expense_tracker_uat 63
70 DB_PDJ 280
71 DB_PETROL 54
72 DB_PETROL_UDAIPUR 91
73 DB_QUANTOM 105
74 db_quotation_tool 99
75 DB_TOURANT_WELL 104
76 DB_VEDASHISH_WELLNESS 69
77 DB_VERA_HARBAL 181
78 DB_WEALTH_BUILDERS 56
79 DEMOBILL 216
80 devccncbizdb 183
81 Dj.Geotraker 278
82 dts 23
83 Duty_V1 124
84 DvineMemories 81
85 DVRtradehub_DB 14
86 E360 10
87 earnskillDB 276
88 EDMSDB 267
89 EduStringsDemo 77
90 empirewoDB 201
91 ensoluti_ 272
92 ERD_V1 128
93 erfolvia_ 245
94 Ernomatics_DB 44
95 ERP_DB_V1 234
96 ERP_SchoolDB 269
97 esp_esphrms_dev 92
98 esp_spark_pos_dev 165
99 esp_sprakpos_windows 131
100 esp_uat_booking 45
101 esp_uat_ecom 46
102 esp_uat_esppos 114
103 esp_uat_pasar_ecom 118
104 esp_uat_prabhubilling_V2 146
105 esp_uat_spark_pos 57
106 ESSL_DB_V1 187
107 EventHub 300
108 facesoft 283
109 faizdb 142
110 familybook_main 110
111 FILEUPLOAD 58
112 FKnitWebBilling 209
113 FOLKSFIN_DSALOS 154
114 FolksHR_MasGen 173
115 FolksHR_Solutions 244
116 Folkshr_V1 149
117 fusionne_pdr 55
118 geotraker_master 279
119 giftus 175
120 GPSDB 88
121 graspdev 210
122 graspprod 207
123 grpenterprise 66
124 gspayin_ 70
125 GURUTEX 218
126 happipe1_happipearls 29
127 happipe1_leoinsys 51
128 happylif_DB 93
129 HaryaliHotSpot 162
130 HealthCampDb 134
131 Helpingzone_DB 48
132 homemeal_DB 85
133 HospitalDrmanagmentDB 87
134 HR_NEW 290
135 HR_PI 291
136 HRPreProd_V1 177
137 HusBlEd 195
138 HussainiDB 196
139 HussainiRetailDB 194
140 HVC_CRM 275
141 HvcVisa_db 136
142 HvcVisa_db1 102
143 HvcVisa_db3 263
144 HVEV 133
145 ics_trans 169
146 ImportBusinessManagerDb 277
147 infinite_AnnaiApirami 227
148 infinite_Apm 235
149 infinite_Billing 232
150 infinite_Jtex 226
151 infinite_KGS 229
152 Infinite_KStore 230
153 infinite_NSR 214
154 infinite_Payroll 233
155 infinite_RKIMPEX 220
156 infinite_Supplier 228
157 infinite_temp 225
158 Interview_V1 129
159 InterviewAppDb 241
160 Inventory_V1 299
161 istanbu1_ 25
162 istanbu1_1 26
163 Jadavweb_BMS 158
164 JoyDeskDb 100
165 JoyDeskDevDb 83
166 justbaked 202
167 kaizentrack_db 284
168 kakarla_school 282
169 KakkarAuto 132
170 KamrejSugar 65
171 kanyaexim 239
172 Khadija-db-new 303
173 labmhcsevic_ 41
174 lakshyas_db 199
175 Leave_V1 126
176 LifeR_ThreeTierArcDB 242
177 liferel1_ChaipaniERAMVCORE_DB 256
178 liferel1_Lab_Core_V3 259
179 liferel1_LimsCorev3 260
180 liferel1_OPD 257
181 liferel1_Support 255
182 lmsdb 163
183 LogicGold_DB 67
184 LOSDEMO_DB 139
185 madhisugar 64
186 magicpoi_ 49
187 malka_sid 254
188 MapsoftDemo 98
189 MapsoftERP 36
190 MapsoftERPMaster 68
191 MapsoftERPSaiShruti 95
192 MapsoftERPSemco 37
193 MapsoftERPSparsh 39
194 MapsoftERPSugarTech 94
195 MapsoftERPVacuumProcess 97
196 MapsoftInfracon 96
197 MapsoftTechnologies 115
198 maruwing_ 268
199 MasGen_ERP 151
200 MasGen_PMS 33
201 master 1
202 MaxHotelBill 82
203 mhcsevic_ 40
204 mithrain_ 266
205 model 3
206 monkish_prod 304
207 msdb 4
208 mybillco 72
209 MyLiveBusinessDB 17
210 N3SCarparking 86
211 NavyaCuremedicsDB 35
212 netbizpl_asianpride 185
213 nextauraFX_DB 6
214 njksteelpayroll 212
215 njksteelpayrolldev 213
216 NJKSUPPLIER 224
217 NovaStarDB 112
218 okgreens_ko 106
219 Onboarding_V1 125
220 OrangeMobileDB 190
221 payDatab 198
222 Payroll_Sarvesh_New 305
223 Payroll_V1 138
224 pdrtest 31
225 pickmyparcels 171
226 portfolio_db 159
227 PostReq_V1 123
228 posunfederation 237
229 PreCare_Dev 27
230 PreCare_Prod 24
231 PreProd_DB 109
232 ProductCrudDb 285
233 qualitychecklist_db 287
234 quotation 231
235 radhey 5
236 reallife_ 120
237 ReallifeEnterprises_DB 122
238 RetailCounterLab_BalajiFootwear 274
239 ridewash_db 22
240 robotrade_DB 12
241 rojrarbe_ 121
242 roshansi_jedb 157
243 ROWaterDB 193
244 roxerena_ftosdb 47
245 royalkin_demo 160
246 royalkin_dwarkesh 178
247 royalkin_sharveelpack 188
248 runwalje_web 172
249 SanfiqoDemo 30
250 SAYANSUGAR 145
251 secreits_odicodemobile 197
252 Senses_db 292
253 Senses_db2 293
254 sensesak_db0 294
255 sensesak_db1 295
256 sensesak_db2 296
257 shayonaphysiocare 252
258 shreeboutique 13
259 Sibi_Bill24 78
260 Sibi_Domaindata 79
261 Sibi_FleetPro 75
262 Sibi_fs_bill24 76
263 Sibi_mybill 74
264 Sibi_Whoisdc 73
265 SKC 222
266 SKCDEV 223
267 smartsolutions 240
268 SmratAshok_DB 144
269 SolarLIMS 84
270 sreeyas1_ 107
271 ssdmindia_DB 147
272 SSLTransDB 11
273 Store_V1 137
274 student_activity 261
275 StudioGlo 7
276 StudioGloT 16
277 suchdb 184
278 svc_noida 170
279 TaskLineDb 174
280 TBCHUB_DB 15
281 TDS 150
282 techbricks_leads 189
283 techbrics_mge 156
284 techbrics_rkdb 253
285 tempdb 2
286 TheBlueSoftDB 117
287 TheedenDb 8
288 tickerbu_ 155
289 TicketMgmt 113
290 TirtaDigital 168
291 TRANSPORTHOME 221
292 TurfDB 179
293 UCSHRDbDev 164
294 UCSPDbDev 301
295 UCSUserDb 21
296 UCSUserDb2 20
297 ukmeldifood_DB 258
298 Universal_DB1 103
299 updatech_AFTO 43
300 updatech_BuildCostDB 273
301 varahied_ 248
302 VDevAIDb 32
303 velvetve_DB 141
304 VoloMac 62
305 VOLTAMP 28
306 vorienxDb26 246
307 Workflow_V1 307