I use SSMS and manually create the database tables, etc., most often, for smaller projects or hobbies.

Enterprise-wide databases are designed by committee or is a hold over from the Paleolithic era.

You will find examples online for the DB script approach if that is all you have to use... hopefully you have SSMS?