title: Delete all files and filegroup example
body: <p>Here is a simple filegroup, </p>
  
  <pre><code>USE master
  GO
  ALTER DATABASE AdventureWorks2012
  ADD FILEGROUP Test1FG1;
  GO
  ALTER DATABASE AdventureWorks2012 
  ADD FILE 
  (
      NAME = test1dat3,
      FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\t1dat3.ndf',
      SIZE = 5MB,
      MAXSIZE = 100MB,
      FILEGROWTH = 5MB
  ),
  (
      NAME = test1dat4,
      FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\t1dat4.ndf',
      SIZE = 5MB,
      MAXSIZE = 100MB,
      FILEGROWTH = 5MB
  )
  TO FILEGROUP Test1FG1;
  GO
  </code></pre>
  
  <p>In this i want to delete all files assosiated with the group Test1FG1, and the group Test1FG1.
  How to do?</p>
  
  <p>Thanks in advance</p>