Similarly, to check for the indexes for a specific table, one can use the following syntax Therefore, we can see that a table emp_details and the corresponding view named as schema are returned back. A user can retrieve the no of tables by using. There are many shell commands which are used for retrieving information about databases. Moving to the topic of auto increment columns, if a user is interested to know the value for the last inserted autoincrement value then this can be obtained by using the SQL command last_insert_rowid()Īdding Index or View to the Created Databaseįor adding a view or index to the database employee.db, execute the commands given belowĮxtracting Database Schema Related Information The output for the above command is as follows
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |