Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-04 : 21:33:04
|
| kareem writes "i need a help in sql server 2000,just iam beginner for sql server 2000 and my doinga project , in which backend tool is sql server how to create sequences in the sql server ?i tried a create sequences command which is used in oracle, but it shows error and i couldn't find in the help alsowhat is the command for describe a table ( to view the fields in the table)please help me, i will greatful foreveryour truely,kareemkareem2020@yahoo.com" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-04 : 23:57:21
|
| There is nothing like sequence in Sql Server. but you can use Identitiy field which will act similar to a sequence.eg:create table test(typeofsequence int identity(1,1),name varchar(20))for description of table or any object for that matter.use sp_help 'objectname' .Check BOL for the same.HTH--------------------------------------------------------------Edited by - Nazim on 03/04/2002 23:58:25 |
 |
|
|
|
|
|
how to create sequences in the sql server