Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Design order of fields
Message
From
02/04/2012 13:36:44
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
02/04/2012 10:18:48
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01540005
Message ID:
01540041
Views:
38
>>I don't believe there is something in design interface. However, it's easy to get programatically using INFORMATION_SCHEMA.Columns view.
>
>Yes, but I need to remove a field. When the table contains over 200 fields it is sometimes very difficult to find it.

I use Toad as a tool. The alter table dialog doesn't sort by column, but view table does, so you can locate your column at ease - then when you know its name, you can easily write an alter table drop column command.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform