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.
It is clear that drinking water before and after you eat aids the digestive process. The general consensus on this is that drinking water about 30 minutes before you eat will help keep the body hydrated which results in optimal digestion. For the liver, this is also important as overall body hydration aids in optimal liver performance.