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.
Fitness professionals recommend protein drinks, primarily after exercise, to replenish and repair the body after working out. But drinking a protein shake before exercise can provide needed energy and reduce the impact exercise has on your body. If your goal is to build muscle, a protein shake before a workout is equally as effective in stimulating muscle protein synthesis as having one after your workout.