L liuyang Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-27 #1 有没有查询表中各个字段的数据类型的SQL语句?怎么写?
Q qianwt Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-27 #3 select b.xtype from sysobjects a, syscolumns b where a.id=b.id and a.name='TableName' and b.name='FieldName'
select b.xtype from sysobjects a, syscolumns b where a.id=b.id and a.name='TableName' and b.name='FieldName'
L liuyang Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-27 #4 我在ORACLE 中是这么写的。现在可以了。谢谢 select column_name,data_type,data_length from all_tab_columns where OWNER='YSCJ' and TABLE_Name='BBB'
我在ORACLE 中是这么写的。现在可以了。谢谢 select column_name,data_type,data_length from all_tab_columns where OWNER='YSCJ' and TABLE_Name='BBB'