SELECT
	OBJECT_NAME(C.OBJECT_ID) AS 'Tabla'
	,C.name AS 'Columna'
	,SCHEMA_NAME(T.schema_id) AS 'Esquema'
	,T.name AS 'Tipo'	
	,C.max_length AS 'Tamaño Maximo en Bytes'
	,C.precision AS 'Precisión'
	,C.scale AS 'Escala'
FROM 
	sys.columns AS C
JOIN 
	sys.types AS T 
ON 
	C.user_type_id = T.user_type_id
WHERE 
	OBJECT_NAME(C.OBJECT_ID)='Card' 
ORDER BY 
	C.OBJECT_ID;

        /// <summary>
        /// Método para validar una dirección de correo electrónico.
        /// </summary>
        /// <param name="email">Correo electrónico a validar.</param>
        /// <returns>Resultado de la validación.</returns>
        public bool ValidateEmail(string email)
        {
            return Regex.IsMatch(email, "^([\\w-\\.]+)@((\\[[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.)|(([\\w-]+\\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\\]?)$");
        }