Board index » delphi » Re: Modifying table structure

Vassiliev V. V.

Delphi Developer
 

Re: Modifying table structure


2007-03-20 05:39:27 AM
delphi114
The easest way is to execute correspongind SQL command, such as CREATE
TABLE, ALTER TABLE. You can use TADOCommand or TADOConnection.Execute().
//------------------------------------------
Regards,
Vassiliev V. V.
www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Mike Saunders" <XXXX@XXXXX.COM>???????/???????? ? ????????
?????????: news:45fef879$XXXX@XXXXX.COM...
Quote

Hi

Is it possible to be able to change the structure of the database I am
working with using ADO ie Add new fields etc or even create new tables
etc provided I have the correct permissions

Thanks

Mike
--

 
 
Mike Saunders

Delphi Developer

2007-03-20 05:54:17 AM

Re: Modifying table structure

Hi
Is it possible to be able to change the structure of the database I am
working with using ADO ie Add new fields etc or even create new tables
etc provided I have the correct permissions
Thanks
Mike
--
 
Mike Saunders

Delphi Developer

2007-03-20 06:04:47 AM

Re: Modifying table structure

I should have said in the previous thread I mean a SQL Server database
Mike