A. The SQL Server specific way (all versions) is :-. select name from sysobjects where type = 'U'. The ANSI standard way (SQL 7 only) is :-. select TABLE_NAME from INFORMATION_SCHEMA.TABLES. 1  reprints. 2  Favorite. 3  EMAIL.
As for what time of day to drink your protein shake, this partially depends on when you workout. The most effective times for drinking your protein shake is first thing in the morning after you wake up, and then again immediately following your workout.
Most people will want to drink a protein shake after their workout. This is because there is a window of a few hours after a workout in which the muscles are primed to take in the protein and carbohydrates they lost during the workout. If you replenish them at that time, you will build more muscle.