Showing posts from August, 2017

Quick Reminder: List All Tables in a Database

Here's a quick reminder of how to generate a list of tables found in a given database: SELECT   TABLE_NAME FROM   nmteachv3.INFORMATION_SCHEMA.TABLES WHERE   TABLE_TYPE = 'BASE TABLE' ORDER  BY   TABLE_NAME   This query will produce results similar to the following: TABLE_NAME AttendanceData Courses Districts Schools SchoolTypes StudentCourses Students StudentTeacherCourses TeacherAttendanceData TeacherCourses Teachers Years YearsDistricts YearsDistrictsSchools YearsTeachersSchools