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.
1 This does not mean you cannot drink water before or after a meal, however, it is recommended that you drink water about half an hour to fifteen minutes before starting your meals and about the same time after finishing your meals. 2  This gap of time helps the body in easy digestion. 3  During meals, have small sips of water.