• You can detach/attach or you can use ALTER DATABASE ... MODIFY and then change the names of the files in the file system, same process as you'd use to move the files to a different location.

    That said, SQL doesn't care about file extensions, you could name a database file .txt and SQL would be fine with it. Only make the change if you need to adhere to some standard or it's bothering you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass