change name of FILEGROUP of a DB in SQL Server

• armm1388

  SSC Eights!

  Points: 808

  More actions

  December 5, 2014 at 1:18 am

  #313642

  hi

  i create a db by following code. now i want to change name of FILEGROUP. how can i do it?

  CREATE DATABASE MyDb

  ON

  PRIMARY ( NAME = MyDat,

  FILENAME = 'c:\data\mydat.mdf'),

  FILEGROUP MyGroup CONTAINS FILESTREAM( NAME = My,

  FILENAME = 'c:\data\my1')

  LOG ON ( NAME = MyLog,

  FILENAME = 'c:\data\mylog.ldf')

  GO

  USE MyDb

  GO

  CREATE TABLE MyTable

  (

  fId INT IDENTITY PRIMARY KEY,

  fData VARBINARY(MAX) FILESTREAM NULL,

  fName NVARCHAR(300),

  RowGuid UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL UNIQUE DEFAULT NEWID()

  )

  GO

  thanks

• Phil Parkin

  SSC Guru

  Points: 246965

  More actions

  December 5, 2014 at 1:33 am

  #1762880

  See here.

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin