Sort Table rows in Designer View in SQL Server

Question

hello  i have table in sql server with id number auto increment1214154546543can i fix this i want it like 123456

dharmendr · Accepted Answer

In editor you cant change this You need to either take backup of all the records and truncate table and reinsert by orderingOr you need to use order by in your query to display the records

Sort Table rows in Designer View in SQL Server

Company

Explore

Follow us

Contact Us