You can. right click DB in enterprise manager, click show all, select all the options objects you want (indexes and constraint in different tab)
Justin > -----Original Message----- > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > Sent: 29 November 2002 12:49 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL db creation > > > I thought you could just select all tables to generate scripts for by > default. Have you tried the DTS and meta data services in > Enterprise manager > ? > > > -----Original Message----- > >From: Ben Lowndes [mailto:[EMAIL PROTECTED]] > Sent: 29 November 2002 12:55 > To: CF-Dev > Subject: [ cf-dev ] SQL db creation > > > Hello, > > I'm running MS SQL2000 and I'd like to reverse engineer the creation of > a database. I can use SQL query analyzer to script the creation of > tables and sp's - although only one at a time - is there anyway to get > it to script everything? > > What I'd also like to do is script the inserts of the initial values - > aside from writing them all myself is there any tool which will script > the inserts based on what's already in the table. > > Yes it's Friday. Yes, I'm being lazy! > > Thanks, > Ben > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
