Tuesday, August 2, 2016

How to view table schema in SQLite

Normally you can

sp_help '<TableName>' will give you the structure of a table in SQL Server but how to do this in SQLite ?

Use

PRAGMA table_info(<table_name>)

eg:
PRAGMA table_info(ImgInfo2)

No comments:

Post a Comment