Android Bridge
http://www.androidwebterminal.com/
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment