Halo,
Sorry lupa ngasih tau kalo sp_rename itu ada di database master, coba sp_rename itu copy ke database dimana tabel yg dimaksud.
regards,
Padu Arsana iW
Frangky <[EMAIL PROTECTED]> wrote:
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]com >
To: <Programmer-VB@yahoogroups. >com
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 Programmer-VB@yahoogroups. , Liung Hartono <[EMAIL PROTECTED]>com
> 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
>
>
>
>
>
>
>
>
>
>
Get your email and more, right on the new Yahoo.com __._,_.___
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
SPONSORED LINKS
| Indonesia phone card | Programmer | Indonesia tour |
| Indonesia travel | Indonesia flower |
Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
