Modify Columns In Data View. In the Navigation Pane locate and double-click. To use the column heading to create fields in Table View you have to select the Include column headers option in the Table View properties.
This is useful for providing a new name to the current table column by using a renaming query. To reorder columns use drag-and-drop for the corresponding cells in the header row. In the Results pane locate the row to be changed or deleted.
While creating and editing views choose the column you want to move.
If you want to convert nvarchar data to datetime then additional parameter is needed to Convert function like. To delete the row right-click the row and select Delete. YesYou can try Convert function to do this. To reorder columns use drag-and-drop for the corresponding cells in the header row.