Veritabanı tablonuzdaki kolon isimlerini öğrenme
- SELECT s.name as TabloAdi, c.name as KolonAdi
FROM sysobjects s inner join syscolumns c on s.id=c.id
WHERE s.xtype = 'u' and s.name='TABLOMUNADI'
ya da
- EXEC sp_columns @table_name = 'TABLOMUNADI'
This entry was written by
and posted on
Çarşamba, Eylül 19, 2007
and filed under
Bookmark the
permalink
.
Follow any comments here with the
RSS feed for this post
.
Post a comment
(
in a new window
)
Comment Form under post in blogger/blogspot