When you need to expand the table layout, apply the Home tab command or the right-click shortcuts to insert a table column in a similar style.

is the name for the constraint being specified. The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form ...

I'm afraid your going to have to name the columns to in your select statement. You can use Query Analyzer to generate the SELECT statement and just edit out the identity column to help save some time.

You can add columns to a table, or modify columns, but the only way to remove a column is to create a new table without a seriesid column, transfer the data from the old table to the new table, drop ...

When the ALTER TABLE statement adds a column to the table, it initializes the column's values to missing in all rows of the table. Use the UPDATE statement to add values to the new column (s).