Pakai select into. Mungkin ada cara lain yg langsung rename, tapi ini yg saya
tahu.
Select * into table2 from table1
go
drop table1
PS : perintah go digunakan supaya perintah pertama dijalanin dulu sampai
selesai, baru perintah
kedua dijalankan. Kalo nggak pakai perintah go, takutnya perintah pertama belom
selesai, udah di
drop di perintah kedua.
Liung's
Frangky wrote:
>
>
> Teman-teman yang terhormat!
>
> Bagaimana code vb untuk rename nama table SQL Server?
>
>
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/Programmer-VB/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
