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


Comments

Post a Comment

Popular posts from this blog

Using Reference Aliases

Image
I recently ran across a situation where two different libraries shared identical namespaces and class names. Visual Studio complained anytime I used one of these classes that it was an ambiguous reference. I needed both libraries -- each contained some unique elements -- so I couldn't ditch one or the other. But, as I said, anytime I tried to use a class that was common (again, via the class name and namespace), I received the ambiguous reference error. This was a real problem, so say the least. However, C# provides a way to specify exactly which library (reference) you mean when you use an object that's common to two or more libraries. Simply put, you use an extern alias  statement. The concept is fairly simple: Give the reference an alias (I used the Properties windows for the reference). Add an extern alias statement, putting it before your using statements. Add a using statement, which effectively links a specific object through the extern alias statement to th...
Read more