How to get column names with query data in sqlite3?

I use sqlite3 console to debug my app while it is executing in Android. Is there a way to show also column names (not only data) with data in result of sql query?

Solution

Yes, after logged into sql prompt mode, execute the following each at a time:

.header on
.mode column

Finding Android SDK on Mac and adding to PATH
Prompt Android App User to Update App if current version <> market version
How to integrate Stripe Payment in Android Java?
Type 'TypeVariable(T)' has no method 'getValue(Nothing?, KProperty<*>)' and thus it cannot serve as a delegate
In version catalog libs I get false errors you can only call the 'from' method a single time
Android: When app was opened with click on notification, clicking on further notifications only opens the app, not changing activity
Applying Flutters app_plugin_loader Gradle plugin imperatively using the apply script method which is deprecated, will be removed in a future release
ContentResolver.takePersistableUriPermission: SecurityException No persistable permission grants found for UID 10434 and Uri content:/
App crashes when changing activities
Android Studio emulator does not have internet
A failure occurred while executing com.android.build.gradle.internal.tasks.FinalizeBundleTask$BundleToolRunnable
Android Material Text Input Layout End Icon Not Showing
Is there a way to keep fragment alive when using BottomNavigationView with new NavController?
Testing a Composable with assertTextEquals() fails with IllegalStateException
W/ManagedChannelImpl: [{0}] Failed to resolve name. status={1}
java.lang.IllegalAccessError: class org.jetbrains.kotlin.kapt3.base.KaptContext Android
build.gradle error: Could not create tastk ':generateLockfiles'. in Flutter project but App is running normal
Exception during working with external system: java.lang.AssertionError in Android Studio Dolphin | 2021.3.1
BaseFragment with viewbinding
How to extract labels.txt file from tflite file?
Validation allow only number and characters in edit text in android
X and Y offset, blur, opacity and colour of shadow in Jetpack Compose?
Can you pass NavHostController to a child Composable in order to allow access to the navController.navigate("Route")?
Error building Android library: Direct local .aar file dependencies are not supported
Layout (Cardview) overlapping below Status bar
adb shell Logcat with Package Name
How to get rid of the bottom border of the React Native Paper TextInput when focused
Issues with android minify after Flutter update 3.22
Flutter build Appbundle Error:* What went wrong: A problem occurred evaluating project ':app'
Room - Schema export directory is not provided to the annotation processor so we cannot export the schema