如题
我现在是把所有的表都列出来了,包括系统表,代码如下:
m_pRecordset = m_pConnection->OpenSchema( adSchemaTables );
while(!(m_pRecordset->adoEOF))
{
_bstr_t table_name = m_pRecordset->Fields->GetItem("TABLE_NAME")->Value;
m_pRecordset->MoveNext();
m_ctrTree.InsertItem( table_name );
}需要如何改进
我现在是把所有的表都列出来了,包括系统表,代码如下:
m_pRecordset = m_pConnection->OpenSchema( adSchemaTables );
while(!(m_pRecordset->adoEOF))
{
_bstr_t table_name = m_pRecordset->Fields->GetItem("TABLE_NAME")->Value;
m_pRecordset->MoveNext();
m_ctrTree.InsertItem( table_name );
}需要如何改进
select name from sysobjects where type = 'U'