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 you are fat and/or you had a decent meal within the last 3 or 4 hours, that protein drink before a workout is not really needed because your body has energy stored up and ready to burn. If you are very lean and/or cutting calories to drop some weight, then you are likely to show up at the gym with no energy.