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.
If performance and good recovery is the goal, then you should aim to eat before and after. A carb/protein blend drink (2/3 to 1 ratio) is often prescribed immediately post-workout. If you have time, eat something with protein and carbs before your run (about 2 hours out if you can). Your choices change depending on the amount of time before or after the workouts. If weight loss is your goal, your eating approach needs to be completely different.