1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br
Cookies Anuncie aqui Patrocinador Anuncios

How do I find a default constraint using INFORMATION_SCHEMA?

Discussão em 'Outras Linguagens' iniciado por Stack, Janeiro 21, 2021.

  1. Stack

    Stack Membro Participativo

    I'm trying to test if a given default constraint exists. I don't want to use the sysobjects table, but the more standard INFORMATION_SCHEMA.

    I've used this to check for tables and primary key constraints before, but I don't see default constraints anywhere.

    Are they not there? (I'm using MS SQL Server 2000).

    EDIT: I'm looking to get by the name of the constraint.

    Continue reading...
    Stack, Janeiro 21, 2021
    #1

Compartilhe esta Página