Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to insert field in SQL Server table
Message
From
27/01/2002 15:51:21
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00611288
Message ID:
00611301
Views:
19
>>>>Hi,
>>>>
>>>>Is there a way (preferably with a visual tool) to insert a field in a SQL Server table so that it comes at a specific position amongst the fields?
>>>>
>>>>TIA,
>>>>
>>>Hi Alex,
>>>
>>>You can do this with Enterprise Manger (EM).
>>>- Right click on a table in EM and choose 'Design Table'
>>>- Right click on the column you want to insert new column before and chose 'Inser Column'
>>>- Fill the new column definition
>>
>>How about moving visually a column that already existed to a different position?
>>
>>TIA,
>>
>Hi Alex,
>
>You can use Cut (Ctrl+X) and Paste (Ctrl+V) to do that.

Thanks again Sergey. This thread merits 6 stars.

Alex
Previous
Reply
Map
View

Click here to load this message in the networking platform