get all table's information concerned

1 get all columnname
select [name] from syscolums where id=object_id('tablename)
2 get all tables
select [name] from SysObjects where type='U'
3 get all datatype of system
select [xtype],[name] from SysTypes 

posted on 2008-01-16 11:08  飞天舞者  阅读(177)  评论(0编辑  收藏  举报

导航

For more information about me, feel free email to me winston.he@hotmail.com