query Access table structures

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Howard Bullock (HowardBullock_at_discussions.microsoft.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 08:23:05 -0800

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.

Relevant Pages

  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Re: SQL -> Oracle
    ... > 2- extracted all my SQL queries in one single file (that was the tedious ... > 3- now whenever I need new query. ... > - Sybase and SQL server prefix their parameters with '@' ... > - Firebird and Oracle have selectable stored procedures so you use them ...
    (borland.public.delphi.non-technical)
  • Re: Embedded Queries?
    ... alter table MyTable ... Columnist, SQL Server Professional ... the time of running the query. ... UPDATE chrisslu SET 'discquantity' = '(SELECT ...
    (comp.databases.ms-sqlserver)
  • Re: SQL query fails
    ... You can't use the same wild card character in all db engines. ... character" wild card in MS SQL & Oracle is the underline; ... > I have a query that works in Oracle and SQL Server, ...
    (microsoft.public.access.queries)
  • Re: ORA-1866 The datetime class is invalid error...the saga continues!
    ... but you could try using a different data provider. ... Use the Microsoft ADO.NET Oracle Provider ... VB.NET to my employers and not being able to query data using a date field ... SQL statements I provided earlier will execute flawlessly in any enviornment ...
    (microsoft.public.dotnet.general)