Saya pakai code dari Mas Paduajus juga, ngga bisa. (muncul pesan error: The
Microsoft Jet database engine cannot find the input table or query
'sp_rename'. Make Sure it exists and that its spelled correctly.
Private Sub Command1_Click()
cnn.Execute "Exec sp_rename tbtransaksi,table10"
End Sub
----- Original Message -----
From: "paduajus" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, September 20, 2006 9:16 AM
Subject: [Programmer-VB] Re: Bagaimana code vb untuk rename nama table SQL
Server
> Hi
>
> Pada sql server sudah disediakan stored procedure untuk merename
> table ataupun mengubah nama kolom(field)
>
> tinggal jalankan saja sp tersebut dari code vb.
>
> Exec sp_rename 'tabellama','tabelbaru'
>
>
> 'untuk rename field
> EXEC sp_rename 'TableName.[Old_ColumnName]', 'TableName.
> [New_ColumnName]', 'COLUMN'
>
>
> semoga membantu.
>
> salam,
>
> Padu Arsana iW
>
>
> --- In [email protected], Liung Hartono <[EMAIL PROTECTED]>
> wrote:
>>
>> 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
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
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/
