namespace Microsoft.Data.Entity.SqlServer.Design.ReverseEngineering.Model
{
    public class TableConstraintColumn
    {
        public const string Query = "SELECT\r\n    quotename(tc.CONSTRAINT_SCHEMA) + quotename(tc.CONSTRAINT_NAME) + quotename(kcu.COLUMN_NAME) [Id]\r\n  , quotename(tc.TABLE_SCHEMA) + quotename(tc.TABLE_NAME) + quotename(kcu.COLUMN_NAME) [ColumnId]\r\n  , quotename(tc.CONSTRAINT_SCHEMA) + quotename(tc.CONSTRAINT_NAME) [ConstraintId]\r\n  , tc.CONSTRAINT_TYPE [ConstraintType]\r\n  , kcu.ORDINAL_POSITION [Ordinal]\r\n  FROM\r\n  INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc\r\n  INNER JOIN\r\n  INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu\r\n  ON tc.CONSTRAINT_CATALOG = kcu.CONSTRAINT_CATALOG\r\n  AND tc.CONSTRAINT_SCHEMA = kcu.CONSTRAINT_SCHEMA\r\n  AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME\r\n  AND tc.TABLE_CATALOG = kcu.TABLE_CATALOG\r\n  AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA\r\n  AND tc.TABLE_NAME = kcu.TABLE_NAME\r\n  WHERE tc.TABLE_NAME IS NOT NULL\r\n";
    }
}