Member Avatar for kritiohri

I have a button and on the click of that button i want to change a the name of few fielnames of Ms access table In Vb.net coding.

  • 2 Contributors
  • 1 Reply
  • 84 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by Teme64
Member Avatar for Teme64

There's no RENAME in SQL. AFAIK the only way to rename field name in Access table is to first DROP field then add field (ALTER). With SQL Server you can rename fields with a stored procedure.

So the options left are:
1) change the field name manually
2) leave the field name as it is and when you read (SELECT) from the table use an alias for the field name

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.