Sandbox::https://github.com/googleapis/nodejs-spanner/blob/main/samples/numeric-add-column.js

This repository was archived by the owner on Mar 4, 2026. It is now read-only.

Repository navigation

History

// Licensed under the Apache License, Version 2.0 (the "License");

// you may not use this file except in compliance with the License.

// You may obtain a copy of the License at

// http://www.apache.org/licenses/LICENSE-2.0

// Unless required by applicable law or agreed to in writing, software

// distributed under the License is distributed on an "AS IS" BASIS,

// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

// See the License for the specific language governing permissions and

// limitations under the License.

'use strict';

async function addNumericColumn(instanceId, databaseId, projectId) {

// [START spanner_add_numeric_column]

/**

* TODO(developer): Uncomment the following lines before running the sample.

// const projectId = 'my-project-id';

// const instanceId = 'my-instance';

// const databaseId = 'my-database';

// Imports the Google Cloud client library

const {Spanner} = require('@google-cloud/spanner');

// creates a client

const spanner = new Spanner({

projectId: projectId,

});

const databaseAdminClient = spanner.getDatabaseAdminClient();

const request = ['ALTER TABLE Venues ADD COLUMN Revenue NUMERIC'];

// Alter existing table to add a column.

const [operation] = await databaseAdminClient.updateDatabaseDdl({

database: databaseAdminClient.databasePath(

projectId,

instanceId,

databaseId,

statements: request,

});

console.log(`Waiting for operation on ${databaseId} to complete...`);

await operation.promise();

console.log(

`Added Revenue column to Venues table in database ${databaseId}.`,

);

// [END spanner_add_numeric_column]

}

module.exports.addNumericColumn = addNumericColumn;

FilesExpand file tree

numeric-add-column.js

Latest commit

History

numeric-add-column.js

File metadata and controls