How to get all constraint on table?

sql-server mssql-jdbc
Shankar Modi picture Shankar Modi · Jan 2, 2015 · Viewed 7.5k times · Source

I want to store tables metadata into other table.So how to get all constraint and its type like whether it primary , unique or foreign key in MS SQL server.

table_name constraint_name constraint_type

user pk_user_id PRIMARY_KEY

user_role fk_role FOREIGN_KEY

user unique_email UNIQUE_KEY

Answer

knkarthick24 picture knkarthick24 · Jan 2, 2015

USE INFORMATION_SCHEMA.TABLE_CONSTRAINTS

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_NAME='tablename'

Related questions

JDBC SQLServerException: "This driver is not configured for integrated authentication."

I am writing a "server-side extension" for SmartFoxServer (SFS). In my login script, I need to make a connection to MS SQL Server, which I am attempting to do using JDBC. I have tested the JDBC code in my debug …

Read More
Which jar to use for connecting to MS SQL server

Can some one please guide me to understand which jar file i need to include in my application to be able to set up a jdbc connection with ms sql server. thanks in advance.

Read More
What can cause the SQL Server JDBC error 'The value is not set for the parameter number 0' for an output parameter access?

I have some Java code that accesses SQL Server 2005 which looks something like this: CallableStatement cstmt = ...; ... // Set input parameters cstmt.registerOutParameter(11, Types.INTEGER); cstmt.execute(); int out = cstmt.getInt(11); And the following exception is thrown from the last line: com.…

Read More