Scenario:You are working as SQL Server developer for Law Firm. You have created table customer in one of the Database "TechBrothersIT" by using below Script.
CREATE TABLE [dbo].[Customer]( [FirstName] [varchar](50) NULL, [LastName] [varchar](50) NULL, [Age] [tinyint] NULL, [PhoneNumber] [char](9) NULL, [DOB] [date] NULL, [Sex] [char](1) NULL )You need to make below changes to dbo.Customer but don't want to write scripts by yourself. You want to use Graphical User Interface to generate these script or even make those change right away.
Change Sex Column Name to Gender
Change First Name to FName
Change LastName to LName and Max size to Varchar (30)
Go to Database and then go to Tables tab. Once you see your required table, Right Click and hit Design.
Now you have two options, You can hit Save button and all changes will be saved. If you would like to generate scripts so you can use in DEV, QA , UAT and Prod. You can click on Generate Script Button and it will generate scripts for you.