Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting columns into a table

Status
Not open for further replies.

Aussum

Programmer
Joined
Feb 13, 2002
Messages
1
Location
US
Enterprise Manager allows you to insert columns into a table, not just append them. What is the T-SQL command that allows that to work? The ADD COLUMN feature of ALTER TABLE only seem to append at the end.
 
If you alter the table and add new columns with T-SQL, the columns will be added after the last column already in the table. There is no reason in a relational database to insert columns in a specific ordinal position. You can create views and queries to select columns in any order you desire. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top