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)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.