Skip to content
Advertisement

CREATE DATABASE using file in default path

I want to create an SQL script that creates a database. Right now, I have this:

However, this generates the following error:

I know the problem is that I did not specify fully qualified path for the filenames. But I want to be able to run this script regardless of the directory structure of the database server. Is there some way to use a default path?

Advertisement

Answer

You can create a database without specifying file details, like:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement