# SqlServerDatabaseResource.WithCreationScript

- Module: [Aspire.Hosting.SqlServer](/reference/api/go/aspire.hosting.sqlserver.md)
- Defined on: [SqlServerDatabaseResource](/reference/api/go/aspire.hosting.sqlserver/sqlserverdatabaseresource.md)
- Version: `17.0.0`
- Kind: `method`

Defines the SQL script used to create the database.

## Remarks

Default script is
```
IF ( NOT EXISTS ( SELECT 1 FROM sys.databases WHERE name = @DatabaseName ) ) CREATE DATABASE [<QUOTED_DATABASE_NAME%gt;];
```

## Definition

```go
type SqlServerDatabaseResource interface {
    // ... omitted for brevity
    WithCreationScript(script string) SqlServerDatabaseResource
}
```

## Signature

```go
WithCreationScript(script string) SqlServerDatabaseResource
```

## Parameters

- `script` (`string`) -- The SQL script used to create the database.

## Returns

[`SqlServerDatabaseResource`](/reference/api/go/aspire.hosting.sqlserver/sqlserverdatabaseresource.md) -- The resource builder.

Returns a handle; failures surface later via `Err()`.

## Defined on

- [SqlServerDatabaseResource](/reference/api/go/aspire.hosting.sqlserver/sqlserverdatabaseresource.md) -- `handle`
