Can I remove the default constraint columns in SQL SERVER?

Answer Posted / suraj

-- CONSTRAINTS are used to limit the type of data that
can go in to a table.
-- You can have multiple CONSTRAINTS in any one column
of a table.
-- You don't have to drop CONSTRAINTS in order to be
able to drop the table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain databases and sql server databases architecture? : Sql server database administration

517


List some of the rules that apply to creating and using a ‘view’

494


When a primary key constraint is included in a table, what other constraints does this imply?

597


What is meant by Active-Passive and Active-Active clustering setup?

558


How to see the event list of an existing trigger using sys.trigger_events?

569






How to generate random numbers with the rand() function in ms sql server?

564


Why use “in” clause in sql server?

554


How to set the current database in ms sql server?

522


What is the difference between indexing and hashing?

543


What is the name of the Database which IBM mainframe uses?

536


What is exporting utility?

539


What is the server name in sql server?

555


What are the 3 types of schema?

597


Describe in brief authentication modes in sql server.

564


How to use "begin ... End" statement structures in ms sql server?

522