How to change the order of columns in SQL?

How to change the order of columns in SQL?

order of columns
SQL Server

In order to maintain the order of columns in SQL we require 2 steps

Disable the “Prevent saving changes that require the table re-creation

  1. Open SQL Server Management Studio.
  2. On the Tools menu, click Options.
  3. In the navigation pane of the Options window, click Designers.
  4. Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

To change the column order

  1. In Object Explorer, right-click the table with columns you want to reorder and select Design.
  2. Select the box to the left of the column name that you want to reorder.
  3. Drag the column to another location within the table.

Here is the quick video

Leave a Reply

Your email address will not be published.

How to whitelist website on AdBlocker?

How to whitelist website on AdBlocker?

  1. 1 Click on the AdBlock Plus icon on the top right corner of your browser
  2. 2 Click on "Enabled on this site" from the AdBlock Plus option
  3. 3 Refresh the page and start browsing the site
%d bloggers like this: