Define identity and uniqueidentifier property of column?



Define identity and uniqueidentifier property of column?..

Answer / Amardeep Singh

'Identity' is a property in SQL Server that automatically generates a unique number for each row when it is inserted into a table. This property ensures each row has a unique identifier. 'uniqueidentifier' is a data type used to store 16-byte globally unique identifiers (GUIDs) in Microsoft Access and SQL Server.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

Define ddl and dml.

1 Answers  


Discuss transparent DBMS?

1 Answers   Ernst Young,


What is mean by dbms?

1 Answers  


What are the basic elements of Base configuration of an oracle Database ?

1 Answers  


Explain ERASE packaged procedure ?

1 Answers  


Explain, why is rdbms better than dbms?

1 Answers  


Explain the difference between physical and logical data independence?

1 Answers  


Explain the concept of acid properties in dbms?

1 Answers  


What is progress open edge?

1 Answers  


Where the data file for system Tablespace is located? What is its name, initial size and maxsize?

1 Answers  


What are vdl and sdl?

1 Answers  


What is the main purpose of a database?

1 Answers  


Categories