---
title: Open Tables Directly
description: Here's how you can open an SQL table without having an INT file by using the Open method.
---

[Mertech Blog ](https://www.mertech.com/blog)

# [Open Tables Directly](https://www.mertech.com/blog/open-tables-directly)

 Written by [Mertech](https://www.mertech.com/blog/author/mertech) | Feb 27, 2008 3:24:00 PM

You can open an SQL table without having an INT file by using the Open method. Although you don’t need the INT file, an FD file is still required to compile your DF/VDF application.

### Open Method Syntax

```
Open "<DriverName>:\<ServerName><DataBaseName>*<Owner>*<TableName>" as <TableName>
```

**Examples** 

```
MySQLopen "MDSMYSQL:\localhostmertech*customer" as customer
```

 

**MS SQLServer**Open "SQL_DRV:\MertechServerSQLServer2012MertechDB*dbo*customer"   as customer

**  
PostGreSQL**open "MDSPGSQL:\localhostframework*customer" as customer

**  
Oracle**open "ORA_DRV:\ora11gmertech*customer"     as customer

### Open As Option in VDF

You can also open an SQL table directly using the "Open As" option in VDF dbExplorer by typing the complete SQL table path.

 

 

[View full post](https://www.mertech.com/blog/open-tables-directly)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Mertech"
  },
  "dateModified" : "2018-02-27T17:39:56.889Z",
  "datePublished" : "2008-02-27T15:24:00Z",
  "headline" : "Open Tables Directly",
  "image" : {
    "@type" : "ImageObject",
    "height" : 133,
    "url" : "https://cdn2.hubspot.net/hubfs/2683630/Imported_Blog_Media/OpenAs.png",
    "width" : 526
  },
  "mainEntityOfPage" : "https://www.mertech.com/blog/open-tables-directly",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Blog"
  }
}
```