How to Alter Database in SQL Server

Hi Developers , Welcome to the Ozanecare. In this article I’ll explain all important steps to alter database in Microsoft SQL server 2019. Anything in SQL Server Management Studio (SSMS) , we can do by two ways. First –> Graphically , Second –> Queries. To Alter Database in SQL SERVER let’s follow steps.

Step 1 : Write Query “Alter Database Employee1 Modify Name = Emp” execute the query.the message you get database name ‘Emp’ has been set. but if you open the path of database the name of ldf and mdf file didn’t change. for help see below image.

Step 2 : we cant modify system database. see below image.

Happy Queries…Thanks.

Post Author: adama