I have just created a server and a database on an instance of Azure.
What are my options in terms of adding tables to this (without using Entity Framework at least for the time being)
Can I use either SSMS or SSDT? Is there any preferred option between these two?
You can use either, the preferred depends entirely on your requirements which, unfortunelty, are somewhat lacking from your question :)
Ed