Pages

Sunday, February 24, 2013

Show Kolom dari Table MS SQL Server


Rumus :

SELECT COLUMN_NAME 'Column' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Nama_Table'




Contoh :


SELECT COLUMN_NAME 'Column' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TMM_MoldDie'

No comments:

Post a Comment