Not always music to your ears (86 tables), but put on some music and it shouldn't take that long.
The reason I cannot use the Create statement is that i need to retain the ID values for each table. IE: I have to drop the IDENTITY column so it doesn't start over at 1, and it keeps all of our gaps. Thanks for the confirmation. I was wondering if it could be done since I could not find it anywhere. On 6/15/05, Anthony Frey <[EMAIL PROTECTED]> wrote: > you can do it during the Create Table > > --- Daniel Elmore <[EMAIL PROTECTED]> wrote: > > > Actually you can't "natively" add the IDENTITY > > property to an existing > > column via T-SQL. You can in enterprise manager > > because it does a ton of > > stuff in the background to make it happen. The T-SQL > > work around is a pain, > > and I don't recommend trying it. > > > > Daniel > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > Behalf Of Brent Helms > > Sent: Wednesday, June 15, 2005 3:55 PM > > To: [email protected] > > Subject: More SQL (Updating a table with IDENTITY) > > > > > > For some reason, I cannot seem to locate a code > > example that properly > > adds the "IDENTITY (1,1) to a pre-existing column". > > This is what I > > have tried, and afterwards, i'll briefly tell you > > the reason. > > > > ALTER TABLE [dbo].[AccountInfo] > > ALTER COLUMN [AccountInfoID] [int] IDENTITY(1,1) > > NOT NULL > > > > I've tried replacing line 2 with a variety of > > things, but I have yet > > to be successful. If you get rid of everything > > after "int" it works. > > > > I'm trying to accomplish the following: > > > > 1) create a temp table mocking the table in question > > 2) populate the temp table with the values from the > > original > > 3) drop the original table > > 4) modify the script that re-creates the original > > table and then re-create > > it > > - constraints and IDENTITY will not be added back > > yet > > 5) push data to the original table from the temp > > table > > 6) add IDENTITY back to the ID columns, add > > constraints > > 7) drop the temp table > > > > Every step looks good, but I cannot get IDENTITY > > back into the > > original table. This hopefully is a syntax > > no-brainer? I know it is > > posisble because you can make the column an IDENTITY > > through > > Enterprise manager. > > > > Regards, > > Brent > > > ---------------------------------------------------------- > > To post, send email to [email protected] > > To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > To subscribe: > > > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > > > > > > > ---------------------------------------------------------- > > To post, send email to [email protected] > > To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > To subscribe: > > > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > > > Anthony C. Frey > 214-529-1507 > [EMAIL PROTECTED] > > > > > > > __________________________________ > Yahoo! Mail > Stay connected, organized, and protected. Take the tour: > http://tour.mail.yahoo.com/mailtour.html > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
