Tagged Questions
3
votes
3answers
3k views
Add a new Column and define its position in a table
I have Table A with 5 columns:
TableA
--
Name
Tel
Email
Address
I want to add a new column (mobile) in between Tel & Email:
TableA
--
Name
Tel
Mobile
Email
Address
If I use
ALTER TABLE ...
2
votes
1answer
187 views
Add columns Query With parameters
Hello all I'm having 1 Question with following query syntax
ALTER TABLE table_name
ADD column_name column-definition;
Question is can we use parameters to column_name field like @column_name? ...