I want to copy primary key columns of a table (only the structure) to a different table in the same database through a SQL Script. I do not want to generate the script thorugh SQL server management studio and run the script. Is this possible through "Create table" statement as i have to copy the structures of nearly 200 tables ?
Any help greatly appreciated !!!