Article View: free.it.visual-basic
Article #3774Re: DROP TABLE?
From: cod
Date: Sun, 24 Mar 2002 11:23
Date: Sun, 24 Mar 2002 11:23
21 lines
1577 bytes
1577 bytes
uhmmm io per rimuovere la tabella in sql uso delete table.. per crearne una create table...... "iv@n" <van@vigilio.it> ha scritto nel messaggio news:%Uul8.38676$1S3.1232624@twister1.libero.it... > Ho creato un database .mdb con Access2000, composto > da 2 tabelle (T1 e T2) e una query (qry1). > > Ora con SQL e da programma Vb, ho necessit๏ฟฝ di modificare > la query, per cui prima di tutto la rimuovo > (comando DROP TABLE qry1) per poi sostituirla: > ma ora non so quale comando SQL usare per > ricreare altra query!! > Come fare? > ADO2.5 > > GRAZIE > >
Technical Details
Message-ID:
<GGin8.17847$pT1.532393@news1.tin.it>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!news.tele.dk!small.news.tele.dk!212.177.105.133!news.mailgate.org!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mailReferences:
<%Uul8.38676$1S3.1232624@twister1.libero.it>Show Full Headers
Complete Article Headers
X-Google-Language: ITALIAN,ASCII X-Google-Thread: f94ee,520e3f355553e251 X-Google-Attributes: gidf94ee,public X-Google-ArrivalTime: 2002-03-24 03:23:26 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!news.tele.dk!small.news.tele.dk!212.177.105.133!news.mailgate.org!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mail From: "cod" <dhsoh@yahoo.com> Newsgroups: free.it.visual-basic References: <%Uul8.38676$1S3.1232624@twister1.libero.it> Subject: Re: DROP TABLE? Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: <GGin8.17847$pT1.532393@news1.tin.it> Date: Sun, 24 Mar 2002 11:23:18 GMT NNTP-Posting-Host: 62.211.157.38 X-Complaints-To: newsmaster@tin.it X-Trace: news1.tin.it 1016968998 62.211.157.38 (Sun, 24 Mar 2002 12:23:18 MET) NNTP-Posting-Date: Sun, 24 Mar 2002 12:23:18 MET Organization: TIN