One table how may column and Primary key

Answer Posted / vignesh lakshmirajan

ONE COLUMN MAY HAVE N NUMBER OF COLUMNS,.. THERE IS NO RESTRICTION IN THAT.. BUT A TABLE SHOULD CONTAIN ONLY ONE PRIMARY KEY, BUT IT MAY HAVE N NUMBER OF UNIQUE KEYS.

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between a local and a global temporary table?

707


How to encrypt Strored Procedure in SQL SERVER?

763


What is extended stored procedures?

718


How to turn off warning messages during php execution?

724


What are the differences between decimal and float in ms sql server?

751






You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

765


What is the maximum rows in sql server table?

670


What is log shipping?

727


What are the approximate numeric data types?

706


What are dml (data manipulation language) statements in ms sql server?

736


What is a mixed extent?

756


Explain about local stored procedure?

702


What is the Disadvantage of indexed sequential file.

783


What is a filestream?

736


How to list all stored procedures in the current database using ms sql server?

813