query Access table structures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I can use SQL to ALTER a tables structure, how can I query the currect
structure to determine if I want to ALTER it? Oracle has a describe command
and I can query the sys* tables in MS SQL.
 
Access does not expose the data structure via a SQL statement, but you can
get it by examining the Fields of the TableDef.

Example:
http://members.iinet.net.au/~allenbrowne/func-06.html

You can certainly execute DDL query statements such as:
ALTER TABLE MyTable ADD COLUMN MyNewTextField TEXT (5);
ALTER TABLE [MyTable] DROP COLUMN [DeleteMe];
ALTER TABLE MyTable ALTER COLUMN MyText2Change TEXT(100);
 
Back
Top