SQL SERVER FILE GROUP NAME AND FILE GROUP ID

SQL SERVER FILE GROUP NAME AND FILE GROUP ID

-- The following query will retrieve the file group name based on a group ID number.

-- THEORY: SELECT FILEGROUP_NAME(id);

-- EXAMPLE

SELECT FILEGROUP_NAME(1);

-- The result is Primary.

-- The following query will retrieve the file group ID based on a group name.

-- THEORY: SELECT FILEGROUP_ID('TEXT STRING NAME');

-- EXAMPLE

SELECT FILEGROUP_ID('Primary');

-- The result is 1