Creating database table

Question

I don't understand why I encounter errors when creating a table especially if I use ;let's assume am creating a customer table and I use Customer_id .They always prompt me error.Please I need help.

Answer 1

do you have permission to create table ?
you have to look if you granted permissions to the user you use.

Answer 2

are you using sql server?... it sometimes locks up if the table is created and you are adding in a new row... i find it easier - If you have to stop the server, which is problematic if other applications are dependants of the server. Your other choice is to dump the database, delete/ recreate and import... Unless of course you have load balancing servers then just take it off line.
But if load balancing is not a luxury then you'd need to let the users know of that particular service, it will be KO for a few minutes ... and at least you wont block other users from going about there day to day.