Oracle Tables

  • Thread starter Thread starter Paula
  • Start date Start date
P

Paula

Hello :

Can you create a table in an Oracle data base using sentences in your .NET code?

I explain:

example: sqlSentence = "CREATE TABLE tableName (...)"
command.commandtext = sqlSentence;
command.ExecuteNonQuery();

If you can, how can you set auto_increment data types?

Thanks

Paula
 
Paula,

yes, you can create tables using SQL DDL commands.

Oracle does not have an auto increment data type as found in SqlSever.
Instead, with Oracle you would use a trigger and a sequence to achieve the
same results.

regards
roy fine
 
Back
Top