Jump to content
Sign in to follow this  

Database tabellen

Recommended Posts


Wanneer ik rechtstreeks in de database nieuwe tabellen aanmaak, krijg ik deze niet te zien in de backend en/of frontend.
Is het mogelijk om tabellen toe te voegen.
bv: bij ps_custumer

SQL.Text:='ALTER TABLE ps_customer ' +
'ADD COLUMN tussenvoegsel VARCHAR(8) AFTER date_upd, ' +
'ADD COLUMN initialen VARCHAR(8) AFTER tussenvoegsel, ' +
'ADD COLUMN aanhef VARCHAR(15) AFTER initialen, ' +
'ADD COLUMN sofi_nummer VARCHAR(15) AFTER aanhef, ' +
'ADD COLUMN straatnaam VARCHAR(45) AFTER sofi_nummer, ' +
'ADD COLUMN huisnummer VARCHAR(6) AFTER straatnaam, ' +
'ADD COLUMN postcode VARCHAR(10) AFTER huisnummer, ' +
'ADD COLUMN plaats VARCHAR(25) AFTER postcode, ' +
'ADD COLUMN provincie VARCHAR(25) AFTER plaats, ' +
'ADD COLUMN land VARCHAR(25) AFTER provincie, ' +
'ADD COLUMN tel1 VARCHAR(15) AFTER land, ' +
'ADD COLUMN tel2 VARCHAR(15) AFTER tel1, ' +
'ADD COLUMN login_naam VARCHAR(15) AFTER tel2, ' +
'ADD COLUMN opmerking VARCHAR(200) AFTER login_naam, ' +
'ADD COLUMN iban VARCHAR(35) AFTER opmerking, ' +
'ADD COLUMN bic VARCHAR(15) AFTER iban, ' +
'ADD COLUMN banknummer VARCHAR(15) AFTER bic, ' +
'ADD COLUMN banknaam VARCHAR(25) AFTER banknummer, ' +
'ADD COLUMN bankadres VARCHAR(25) AFTER banknaam, ' +
'ADD COLUMN bankplaats VARCHAR(25) AFTER bankadres, ' +
'ADD COLUMN bankland VARCHAR(25) AFTER bankplaats, ' +
'ADD COLUMN korting DOUBLE AFTER bankland';

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More