How to write sql query to create column of type Yes/No with checkbox?

[Chandan Kr Sah]

How to write sql query to create column of type Yes/No with checkbox.By default it is creating with textbox.
I am struglling for the same from one week.
So plese provide me any solution for the same.

Thanks in advance for any kind of help.

[patjones]

Is it possible for you to simply open the table in design view and add the column that way?

Pat

[Chandan Kr Sah]

I required sql script for that, because I have to send that script to client.

Thanks for reply...

But I required sql script for that, because I have to send that script to client.They will run the query and will able to select/deselect the checkboxes as Active/Inactive employee.