SQLXP

Tables


The object viewer displays a tables columns, primary keys, foreign keys, indexes, and data. You can edit the column grid directly to change column names, data types, sizes, defaults and nullablilty. After modifying the table structure, click the view SQL button to see what SQL command will be used. You can also add new columns and remove existing columns.

Under Primary Keys you can add new keys and drop existing ones.

Under Foreign Keys you can add new keys and drop existing ones.

Under Indexes you can add indexes and drop existing ones.

Under Data you can insert, update, and delete data from the table quickly and easily.