Site Menu
- Home
- Products
- NexusDB
- Nexus Quality Suite
- NexusDB Drivers & Connectors
- Nexus Remoting
- Nexus Memory Manager
- Some of our Customers
- Testimonials and use(r)s
- Downloads
- Documentation
- Support
- Pricing & Orders
- About
- Community
- My Nexus
- Recently Updated ...
- Search...
- Site Login
Search
SQL Alias Management
Mon, 03/09/2009 - 21:59 | hdanzl
Something you SQL affictionados will love is the ability to create database aliases IN SQL:
CREATE ALIAS AliasName FROM {<pathname> | MEMORY}
DROP ALIAS AliasName
ALTER ALIAS AliasName SET PATH TO <pathname>
<pathname> ::= <character string literal> [ ENFORCE ]
DROP ALIAS AliasName
ALTER ALIAS AliasName SET PATH TO <pathname>
<pathname> ::= <character string literal> [ ENFORCE ]
ENFORCE btw will create the directory on the server if it's not yet there. Also note the word MEMORY which creates a SQL-accessible in-memory databases (which is persistent until the server is stopped).
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm