0

Creating database table

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.

16th Feb 2017, 10:29 AM
Richard Atama Guema
Richard Atama Guema - avatar
2 odpowiedzi
+ 1
do you have permission to create table ? you have to look if you granted permissions to the user you use.
16th Feb 2017, 11:02 AM
Chaieb Mohamed Yassine
Chaieb Mohamed Yassine - avatar
+ 1
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.
16th Feb 2017, 11:18 AM
Paul Millr
Paul Millr - avatar