hello,
Can one change the field name in a table using sql query. The table contains data. So without deleting data one has to change the field name of one field in a table.
For example, there exists a table called apple and its fields have these respective field names - a,b,c. Now i want to change field name 'a' to 'z'. The point to be remembered is that the table contains data.
Can one change the field name in a table using sql query. The table contains data. So without deleting data one has to change the field name of one field in a table.
For example, there exists a table called apple and its fields have these respective field names - a,b,c. Now i want to change field name 'a' to 'z'. The point to be remembered is that the table contains data.