FireDAC 之FDMetaInfoQuery

標籤：

FDMetaInfoQuery

MetaInfoKind屬性有17種類型，擷取資料庫名稱、表、欄位、主鍵等資訊。強大強大，不用寫sql語句

mkNone
mkCatalogs
mkSchemas
mkTables
mkTableFields
mkIndexes
mkIndexFields
mkPrimaryKey
mkPrimaryKeyFields
mkForeignKeys
mkForeignKeyFields
mkPackages
mkProcs
mkProcArgs
mkGenerators
mkResultSetFields
mkTableTypeFields

 

 FDMetaInfoQuery1->MetaInfoKind = mkTables;
 FDMetaInfoQuery1->Open();

 

FDMetaInfoQuery1->MetaInfoKind = mkTableFields;
 FDMetaInfoQuery1->Open(edtTableName->Text);

 

 FDMetaInfoQuery1->MetaInfoKind = mkPrimaryKey;
 FDMetaInfoQuery1->Open(edtTableName->Text);

 

 FDMetaInfoQuery1->MetaInfoKind = mkPrimaryKeyFields;
 FDMetaInfoQuery1->Open(edtTableName->Text,PKName); ?? 怎麼賦值參數

FireDAC 之FDMetaInfoQuery