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 Make sure you are well hydrated before, during, and after exercise. Replace your fluids, whether you feel thirsty or not.  A general recommendation is to drink 24 ounces of non-caffeinated fluid 2 hours before exercise. Drinking an additional 8-ounces of water or sports drink right before exercise is also helpful.