ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("ALTER TABLE TableName ALTER COLUMN ColumnName AUTOINCREMENT(1,1);"); //(1,1)->The starting value will be 1, and it will increment by 1.
ADOQuery1->ExecSQL();

 SQLConnection1->Connected=false;
SQLConnection1->Params->Clear();
SQLConnection1->Params->Add("BlobSize=-1");
SQLConnection1->Params->Add("CommitRetain=False");
SQLConnection1->Params->Add("Database="+ExtractFilePath(Application->ExeName)+"DB.fdb");
SQLConnection1->Params->Add("DriverName=Interbase");
SQLConnection1->Params->Add("LocaleCode=0000");
SQLConnection1->Params->Add("Password=masterkey");
SQLConnection1->Params->Add("RoleName=RoleName");
SQLConnection1->Params->Add("SQLDialect=3");
SQLConnection1->Params->Add("Interbase TransIsolation=ReadCommited");
SQLConnection1->Params->Add("User_Name=sysdba");
SQLConnection1->Params->Add("WaitOnLocks=True");
SQLConnection1->Connected=true;

Zoznam tabuliek/List of Tables

select rdb$relation_name
from rdb$relations
where rdb$view_blr is null 
and (rdb$system_flag is null or rdb$system_flag = 0); 

Embeded databáza nepotrebuje inštalovať server - stačí nakopírovať príslušné DLL a samotnú DB (súbor *.FDB).
(viac…)

Stiahneme si súbory MySQL 5.1 http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-noinstall-5.1.31-win32.zip/from/http://mysql.linux.cz/
Obsah archívu rozbalíme do C:\mysql.
(viac…)