--- In ITCENTER@yahoogroups.com, "Taufik" <alphayed_cool@...> wrote:
>
> Dear all,
> gmn caranya edit tabel kalo pke sql 2008 tnpa mendelete tabel itu
> dlu..soalnya ane coba berkali2 gagal disave trs..
>
>
> thx
>
yg mau diedit nama table atau data tablenya gan?
klo mau edit (rename) nama table bs pakai :
USE database_name GO
sp_rename 'old_table', 'new_table'
GO
klo mau edit (rename) nama kolomnya aja bs pakai :
USE database_name GO
sp_rename 'table_name.old_column', 'new_column', 'COLUMN'
GO
klo mau edit tipe data kolomnya aja bs pakai :
ALTER TABLE table_name
ALTER COLUMN column_name datatype
klo mau edit data tablenya bs pakai :
UPDATE table_name
SET column1 = value1,column2 = value2,...
WHERE some_column = some_value;
oia gan, saran saya sebelum diedit2 tabelnya, ada baiknya di backup dl table or
databasenya, jd klo misal ada error bs lsg di restore :D
thanks,,
------------------------------------
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : itcenter-h...@yahoogroups.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
itcenter-dig...@yahoogroups.com
itcenter-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
itcenter-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
