CreateSQLiteDatabase (arcpy)

Summary

Creates a new SQLite database.

Syntax

CreateSQLiteDatabase (sqlite_database_path, {spatial_type})

Parameter	Explanation	Data Type
sqlite_database_path	Location of the SQLite database to be created and the name of the SQLite database in the file name. You must include the .sqlite extension.	String
spatial_type	The geometry type to install with the new SQLite database. You can only use one geometry type in SQLite databases. ST_GEOMETRY —Esri's spatial storage type. This is the default. SPATIALITE —SpatiaLite spatial storage type.	String

Return Value

Data Type	Explanation
File	An SQLite database (.sqlite extension) with either ST_Geometry or SpatiaLite geometry type installed.

Code Sample

CreateSQLiteDatabase example

Create an SQLite database.

import arcpy

# Set local variables
sqlite_database_path = 'C:/Data/Counties.sqlite'

# Execute CreateSQLiteDatabase
arcpy.gp.CreateSQLiteDatabase(sqlite_database_path, "ST_GEOMETRY")