Constraints

J

Jim Heavey

A couple of questions on tables....

If you execute a SQL statement (SQL2000) and bring down all the attributes in
a table, then the constraints come down as well? What if yoy select some
attributes but not all, but all the fields necessary for creating the
constraints, are the constraints extracted?

If you execute an SQL statment which brings in data from several tables, you
have to create your own constraints?

If you run a SQL statement and no rows are returned, is the datatable created
with all of the columns or do you have use the method to fill the schema?
 
G

Greg

Constraints are not brought back from sql server. You have to build these
yourself.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top