Hi, I will also add that the 'visual' environment of MSSQL is surely the most complete, primary there is no need to use a taf to do this maybe you are planing to use a such possiblity to embed some automation or tasks in the taf (installation of the application with the database creation, global database administration...), so let us know.
Another tips: You could also obtain the 'general SQL script' menu by selecting almost any icon in the enterprise manager and rightclicking it (database, tables, procedures...), if you generate a complete database script don't forget to check the 'script indexes' 'script...' in the 'options' tab of the dialog Gauthier PS: thanks to Scott to not being as exhaustive as he is so I can add a little something ;) ----- Original Message ----- From: "Scott Cadillac" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 12:41 AM Subject: Re: Witango-Talk: Added and changing SQL tables > Hi Dan, > > You can use a Direct_DBMS Action and Transact-SQL to create and modify > Tables, Fields, Indexes, Triggers, etc... > > I don't have TAF for this, but check out the Query Analyzer that comes with > SQL-Server - it'll teach you and show you templates for doing exactly these > kinds of things. Also, when you are looking at the Design View of a Table in > Enterprise Manager, use the 'Generate SQL Script' button to show you how > Transact-SQL is used to build tables and such. > > Good Luck. Cheers.... > > > Scott Cadillac > http://xml-extra.net > [EMAIL PROTECTED] > > > ----- Original Message ----- > From: "Dan Stein" <[EMAIL PROTECTED]> > To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> > Sent: Monday, April 29, 2002 3:25 PM > Subject: Witango-Talk: Added and changing SQL tables > > > > Seems to me there should be away for me to use a Tango app to added or > > modify SQL tables. I'm using SQL 2000. Anyone have one written? > > > > Dan > > > > > > -- > > Dan Stein > > Digital Software Solutions > > 799 Evergreen Circle > > Telford PA 18969 > > 215-799-0192 > > 610-256-2843 > > Fax 413-410-9682 > > FMP,Tango, EDI,SQL 7 > > [EMAIL PROTECTED] > > www.dss-db.com > > > > > > ________________________________________________________________________ > > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
