Class Table

Create a Table object to interact with a table in a Cloud Spanner database.

Package

@google-cloud/spanner!

Constructors

(constructor)(database, name)

constructor(database:Database,name:string);

Constructs a new instance of theTable class

Parameters
TypeNameDescription
Databasedatabase
stringname

Properties

database

database:Database;
Property Value
TypeDescription
Database

name

name:string;
Property Value
TypeDescription
string

Methods

create(schema, gaxOptions)

create(schema:Schema,gaxOptions?:CallOptions):Promise<CreateTableResponse>;
Parameters
TypeNameDescription
Schemaschema
CallOptionsgaxOptions
Returns
TypeDescription
Promise<CreateTableResponse>

create(schema, callback)

create(schema:Schema,callback:CreateTableCallback):void;
Parameters
TypeNameDescription
Schemaschema
CreateTableCallbackcallback
Returns
TypeDescription
void

create(schema, gaxOptions, callback)

create(schema:Schema,gaxOptions:CallOptions,callback:CreateTableCallback):void;
Parameters
TypeNameDescription
Schemaschema
CallOptionsgaxOptions
CreateTableCallbackcallback
Returns
TypeDescription
void

createReadStream(request, options)

createReadStream(request:ReadRequest,options?:TimestampBounds):PartialResultStream;

Create a readable object stream to receive rows from the database using key lookups and scans.

[StreamingRead API Documentation](https://cloud.google.com/spanner/docs/reference/rpc/google.spanner.v1#google.spanner.v1.Spanner.StreamingRead) [ReadRequest API Documentation](https://cloud.google.com/spanner/docs/reference/rpc/google.spanner.v1#google.spanner.v1.ReadRequest)

Parameters
TypeNameDescription
ReadRequestrequest
TimestampBoundsoptions

[Transaction options](https://cloud.google.com/spanner/docs/timestamp-bounds).

Returns
TypeDescription
PartialResultStream

{PartialResultStream} A readable stream that emits rows.

delete(gaxOptions)

delete(gaxOptions?:CallOptions):Promise<DropTableResponse>;
Parameter
TypeNameDescription
CallOptionsgaxOptions
Returns
TypeDescription
Promise<DropTableResponse>

delete(callback)

delete(callback:DropTableCallback):void;
Parameter
TypeNameDescription
DropTableCallbackcallback
Returns
TypeDescription
void

delete(gaxOptions, callback)

delete(gaxOptions:CallOptions,callback:DropTableCallback):void;
Parameters
TypeNameDescription
CallOptionsgaxOptions
DropTableCallbackcallback
Returns
TypeDescription
void

deleteRows(keys, options)

deleteRows(keys:Key[],options?:DeleteRowsOptions|CallOptions):Promise<DeleteRowsResponse>;
Parameters
TypeNameDescription
Key[]keys
DeleteRowsOptions |CallOptionsoptions
Returns
TypeDescription
Promise<DeleteRowsResponse>

deleteRows(keys, callback)

deleteRows(keys:Key[],callback:DeleteRowsCallback):void;
Parameters
TypeNameDescription
Key[]keys
DeleteRowsCallbackcallback
Returns
TypeDescription
void

deleteRows(keys, options, callback)

deleteRows(keys:Key[],options:DeleteRowsOptions|CallOptions,callback:DeleteRowsCallback):void;
Parameters
TypeNameDescription
Key[]keys
DeleteRowsOptions |CallOptionsoptions
DeleteRowsCallbackcallback
Returns
TypeDescription
void

drop(gaxOptions)

drop(gaxOptions?:CallOptions):Promise<DropTableResponse>;
Parameter
TypeNameDescription
CallOptionsgaxOptions
Returns
TypeDescription
Promise<DropTableResponse>

drop(callback)

drop(callback:DropTableCallback):void;
Parameter
TypeNameDescription
DropTableCallbackcallback
Returns
TypeDescription
void

drop(gaxOptions, callback)

drop(gaxOptions:CallOptions,callback:DropTableCallback):void;
Parameters
TypeNameDescription
CallOptionsgaxOptions
DropTableCallbackcallback
Returns
TypeDescription
void

insert(rows, options)

insert(rows:object|object[],options?:InsertRowsOptions|CallOptions):Promise<InsertRowsResponse>;
Parameters
TypeNameDescription
object | object[]rows
InsertRowsOptions |CallOptionsoptions
Returns
TypeDescription
Promise<InsertRowsResponse>

insert(rows, callback)

insert(rows:object|object[],callback:InsertRowsCallback):void;
Parameters
TypeNameDescription
object | object[]rows
InsertRowsCallbackcallback
Returns
TypeDescription
void

insert(rows, options, callback)

insert(rows:object|object[],options:InsertRowsOptions|CallOptions,callback:InsertRowsCallback):void;
Parameters
TypeNameDescription
object | object[]rows
InsertRowsOptions |CallOptionsoptions
InsertRowsCallbackcallback
Returns
TypeDescription
void

read(request, options)

read(request:ReadRequest,options?:TimestampBounds):Promise<ReadResponse>;
Parameters
TypeNameDescription
ReadRequestrequest
TimestampBoundsoptions
Returns
TypeDescription
Promise<ReadResponse>

read(request, callback)

read(request:ReadRequest,callback:ReadCallback):void;
Parameters
TypeNameDescription
ReadRequestrequest
ReadCallbackcallback
Returns
TypeDescription
void

read(request, options, callback)

read(request:ReadRequest,options:TimestampBounds,callback:ReadCallback):void;
Parameters
TypeNameDescription
ReadRequestrequest
TimestampBoundsoptions
ReadCallbackcallback
Returns
TypeDescription
void

replace(rows, options)

replace(rows:object|object[],options?:ReplaceRowsOptions|CallOptions):Promise<ReplaceRowsResponse>;
Parameters
TypeNameDescription
object | object[]rows
ReplaceRowsOptions |CallOptionsoptions
Returns
TypeDescription
Promise<ReplaceRowsResponse>

replace(rows, callback)

replace(rows:object|object[],callback:ReplaceRowsCallback):void;
Parameters
TypeNameDescription
object | object[]rows
ReplaceRowsCallbackcallback
Returns
TypeDescription
void

replace(rows, options, callback)

replace(rows:object|object[],options:ReplaceRowsOptions|CallOptions,callback:ReplaceRowsCallback):void;
Parameters
TypeNameDescription
object | object[]rows
ReplaceRowsOptions |CallOptionsoptions
ReplaceRowsCallbackcallback
Returns
TypeDescription
void

update(rows, options)

update(rows:object|object[],options?:UpdateRowsOptions|CallOptions):Promise<UpdateRowsResponse>;
Parameters
TypeNameDescription
object | object[]rows
UpdateRowsOptions |CallOptionsoptions
Returns
TypeDescription
Promise<UpdateRowsResponse>

update(rows, callback)

update(rows:object|object[],callback:UpdateRowsCallback):void;
Parameters
TypeNameDescription
object | object[]rows
UpdateRowsCallbackcallback
Returns
TypeDescription
void

update(rows, options, callback)

update(rows:object|object[],options:UpdateRowsOptions|CallOptions,callback:UpdateRowsCallback):void;
Parameters
TypeNameDescription
object | object[]rows
UpdateRowsOptions |CallOptionsoptions
UpdateRowsCallbackcallback
Returns
TypeDescription
void

upsert(rows, options)

upsert(rows:object|object[],options?:UpsertRowsOptions|CallOptions):Promise<UpsertRowsResponse>;
Parameters
TypeNameDescription
object | object[]rows
UpsertRowsOptions |CallOptionsoptions
Returns
TypeDescription
Promise<UpsertRowsResponse>

upsert(rows, callback)

upsert(rows:object|object[],callback:UpsertRowsCallback):void;
Parameters
TypeNameDescription
object | object[]rows
UpsertRowsCallbackcallback
Returns
TypeDescription
void

upsert(rows, options, callback)

upsert(rows:object|object[],options:UpsertRowsOptions|CallOptions,callback:UpsertRowsCallback):void;
Parameters
TypeNameDescription
object | object[]rows
UpsertRowsOptions |CallOptionsoptions
UpsertRowsCallbackcallback
Returns
TypeDescription
void

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-10-30 UTC.