ALTER

this works in both SQL Server and Access

ALTER TABLE zCUSTOMERS 
DROP COLUMN Address

this only works in Access

ALTER TABLE zCUSTOMERS 
ADD COLUMN Address NVARCHAR(60)

this only works in SQL Server as the COLUMN keyword is not permitted

ALTER TABLE zCUSTOMERS 
ADD Address NVARCHAR(60)

this works in both SQL Server and Access

ALTER TABLE zCUSTOMERS 
DROP CONSTRAINT ConstraintName1

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext