Get DB file info and sizes

SQF |

280 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

span class="re5"> use [master]
go
 
declare @k2DbName nvarchar(255) = 'K2';
 
select d.name [DB Name], f.name [File Name], f.physical_name, f.type_desc, f.size
from sys.databases d
inner join sys.master_files f on f.database_id = d.database_id
where d.name = @k2DbName
order by f.type, f.file_id

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

Get DB file info and sizes

Comments